Message-ID: <4AE72BEE.5070801@rp-online.de>
Date: Tue, 27 Oct 2009 18:20:46 +0100
From: Thomas Pundt <mlists@rp-online.de>
Reply-To: thomas.pundt@rp-online.de
User-Agent: Thunderbird 2.0.0.23 (Macintosh/20090812)
MIME-Version: 1.0
To: Marc Mamin <M.Mamin@intershop.de>
CC: pgsql-sql@postgresql.org
Subject: Re: record to columns: syntax question and strange behaviour
References: 
 <C4DAC901169B624F933534A26ED7DF31010A5364@JENMAIL01.ad.intershop.net>
In-Reply-To: 
 <C4DAC901169B624F933534A26ED7DF31010A5364@JENMAIL01.ad.intershop.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Marc Mamin schrieb:
> how should I retrieve the result from a function with some OUT
> paramenters?
> 
> (PG is  8.3.7)
> 
> here a short example to illustrate my question:
> 
> CREATE OR REPLACE FUNCTION test (In a int, OUT b int, OUT c int) AS
> $BODY$
> BEGIN
>   b:=a+1;
>   c:=a+2;
>   raise notice 'done: %', a;
> END
> 
> $BODY$
>   LANGUAGE 'plpgsql' IMMUTABLE

IMO easiest would be to include a   RETURNS SETOF record   in the
function declaration and a   return next;   statement in the function
body. E.g.


CREATE OR REPLACE FUNCTION test (In a int, OUT b int, OUT c int)
RETURNS SETOF record
AS
$BODY$
BEGIN
   b:=a+1;
   c:=a+2;
   return next;
END
$BODY$
   LANGUAGE 'plpgsql'

and then issue

SELECT * FROM test(1);

Ciao,
Thomas