Re: [GENERAL] Question from a newbie

2004-10-07 Thread Michael Fuhr
On Thu, Oct 07, 2004 at 10:55:03PM -0400, Tom Lane wrote: > return plpy.execute("select getcountrycode(\'9821788\')",1) plpy.execute() returns a result object; querying a function that returns a result object will probably look like this: test=> select test4(); test4

Re: [GENERAL] Question from a newbie

2004-10-07 Thread Tom Lane
"Kiarash Bodouhi" <[EMAIL PROTECTED]> writes: > 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 getcountryc

[GENERAL] Question from a newbie

2004-10-07 Thread Kiarash Bodouhi
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