Re: Functions that return both Output Parameters and recordsets

Pavel Stehule escribió:
> Hello
>
> it's not possible. PostgreSQL doesn't support multiple recordset. You
> have to have two functions.

The other idea is to declare the function to return SETOF refcursor (or
have an OUT refcursor param), and return two refcursors open with the
different recordsets.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.