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