View Single Post

   
  #6 (permalink)  
Old 04-09-2008, 05:49 PM
Alvaro Herrera
 
Posts: n/a
Default 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.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote