Re: Creating a PL/pgSQL function that returns multiple out parameters and refcursor

On Fri, Oct 3, 2014 at 1:15 AM, Néstor Boscán <nestorjb(at)gmail(dot)com> wrote:
> Ho do I create a PL/pgSQL function that returns multiple out parameters and
> a refcursor.

Using a plain "RETURN;" is just but fine, your output parameters are
being set internally in the function:
=# create function myfunction(id_base in int, id1 out int, id2 out varchar)
returns record as $$
begin
id1 := id_base * 2;
id2 := id_base * 3;
return;
end;
$$ language plpgsql;
CREATE FUNCTION
=# select * from myfunction(3);
id1 | id2
-----+-----
6 | 9
(1 row)
=# select * from myfunction(4);
id1 | id2
-----+-----
8 | 12
(1 row)

Regards,
--
Michael