Re: is it possible to recover more than one recordset or cursor from a function?

From: "Albe Laurenz" <all(at)adv(dot)magwien(dot)gv(dot)at>
To: <guillermoariast(at)linuxwaves(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: is it possible to recover more than one recordset or cursor from a function?
Date: 2007-06-18 07:22:35
Message-ID: AFCCBB403D7E7A4581E48F20AF3E5DB2036897B0@EXADV1.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ....

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-06-18 07:31:21 Re: is it possible to recover more than one recordset or cursor from a function?
Previous Message Mavinakuli, Prasanna (STSD) 2007-06-18 07:13:45 Core reported from vaccum function.