Question from a newbie - Mailing list pgsql-general

From Kiarash Bodouhi
Subject Question from a newbie
Date
Msg-id 067f01c4acc7$96a93f00$0a00a8c0@kibotop2
Whole thread Raw
In response to Re: regular expression searches  (David Fetter <david@fetter.org>)
Responses Re: Question from a newbie  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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




pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: Index problem.... GIST (tsearch2)
Next
From: Michael Fuhr
Date:
Subject: Re: flattened tables with normalized tables