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




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to