| From: | "Kiarash Bodouhi" <kbodouhi(at)yahoo(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Question from a newbie |
| Date: | 2004-10-07 23:44:27 |
| Message-ID: | 067f01c4acc7$96a93f00$0a00a8c0@kibotop2 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-10-07 23:44:35 | Re: Index problem.... GIST (tsearch2) |
| Previous Message | Greg Stark | 2004-10-07 23:40:05 | Re: Index problem.... GIST (tsearch2) |