Re: is it possible to recover more than one recordset or cursor from a function?

2007/6/18, Albe Laurenz <all@adv.magwien.gv.at>:
> guillermo arias wrote:
> >
> > is it possible to recover more than one recordset or cursor
> > from a function?
> > I use to do it in ms sql server, but it is a mistery for me
> > in postgre.
>
> CREATE FUNCTION returns2cursors(OUT c1 refcursor, OUT c2 refcursor)
> LANGUAGE plpgsql AS ....
>

or CREATE FUNCTION ... RETURNS SETOF CURSOR
BEGIN
...
END

you can find notice about it in documentation
http://www.postgresql.org/docs/8.2/interactive/plpgsql-cursors.html

regards
Pavel Stehule