On 05/23/2011 06:44 AM, Michael McInnis wrote:
> I've seen numerous references to this syntax but haven't found where
> you issue the command.
>
> Tried it in a testpython.py file, no luck.
> Can't find a plpy file anywhere.
>
> I know it's going to be simple but need help.
> rv = plpy.execute("SELECT * FROM my_table", 5)
> Thanks
>
> Michael McInnis 6033 44th Ave. N.E. Seattle, WA 98115 206 517-4701
>
You have to run it as a plpythonu function as in:
create function test() returns int as
$$
rv=plpy.execute("SELECT * FROM my_table", 5)
for row in rv:
do something
return 1
$$ langauge 'plpythonu';