Question from a newbie

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: Raw Message | Whole Thread | 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

In response to

Responses

Browse pgsql-general by date

  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)