pl/python out params - Mailing list pgsql-sql

From Imre Horvath
Subject pl/python out params
Date
Msg-id 1281192586.5038.3.camel@cytherian.blemidon.dyndns.org
Whole thread Raw
Responses Re: pl/python out params  (Richard Albright <ralbright@insiderscore.com>)
Re: pl/python out params  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: "Marc Mamin"
Date:
Subject: Re: workaround for missing ROWNUM feature with the help of GUC variables
Next
From: LaboRecherche
Date:
Subject: Using SKYLINE command on PostgreSQL