2007/6/18, Albe Laurenz <[EMAIL PROTECTED]>:
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
