Re: Where are plpy.execute python commands issued? - Mailing list pgsql-general

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';