Question from a newbie

Поиск
Список
Период
Сортировка
От Kiarash Bodouhi
Тема Question from a newbie
Дата
Msg-id 067f01c4acc7$96a93f00$0a00a8c0@kibotop2
обсуждение исходный текст
Ответ на Re: regular expression searches  (David Fetter <david@fetter.org>)
Ответы Re: Question from a newbie  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello All

I used to be MySQL user. I recently changed to PostGres. It is much more
fun. I have two questions. First, is it possible to call other functions
from plpython functions? I used following but didn't work. Any comments?

CREATE OR REPLACE FUNCTION test4()
  RETURNS "varchar" AS
'
return plpy.execute("select getcountrycode("9821788")",1)
'
  LANGUAGE 'plpythonu' VOLATILE;


Also, do you know any better way (apart from psql) to enter and test
functions? I used pgAdmin, but it didn't work properly with plpython. I
guess the indentation is not right and everytime I have to create the
function from psql in order to work. A little bit strange but it happened! I
don't know if I am doing something wrong or not but it seems no other person
complained.

Thanking you in advance
Regards
kia




В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Index problem.... GIST (tsearch2)
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: flattened tables with normalized tables