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.
pre.cjk { font-family: "DejaVu Sans",monospace; }p { margin-bottom: 0.08in; }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';