Re: [SQL] pl/python out params

2010-08-07 Thread Tom Lane
Imre Horvath writes: > Is there a way to use output parameters with a pl/python fucntion? At the moment I think plpython only supports a single OUT param. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscriptio

Re: [SQL] pl/python out params

2010-08-07 Thread Richard Albright
first define a custom type, then drop the out parameters. create type mytype as ( i integer, j text ); create or replace function outtest() returns mytype as $BODY$ i = 1 j = 'something' return ( i, j ) $BODY$ language plpythonu; select * from outtest(); i | j ---+--- 1 | someth