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
