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 | something (1 row) On 08/07/2010 10:49 AM, Imre Horvath wrote:
Hi! Is there a way to use output parameters with a pl/python fucntion? I've tried with no luck: if I define out parameters, it says return type must be record, if I define a record return type, I get an error on executing that pl/python doesn't support record return type... My simple test func is: create or replace function outtest(out i integer, out j text) returns boolean as $BODY$ i = 1 j = 'something' return True $BODY$ language plpythonu; Thanks in advance: Imre Horvath
-- *Rick Albright* Senior Quantitave Analyst Web: www.insiderscore.com <https://www.insiderscore.com/> Email: ralbri...@insiderscore.com <mailto:ralbri...@insiderscore.com>
