Re: Functions that return both Output Parameters and recordsets

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Jeremy Nix <Jeremy(dot)Nix(at)sfsltd(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Functions that return both Output Parameters and recordsets
Date: 2007-06-11 13:30:21
Message-ID: 20070611133021.GD4251@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-06-11 13:32:15 Re: transaction problem using cursors
Previous Message Pit M. 2007-06-11 13:28:22 Re: transaction problem using cursors