Postgres Pro
Downloads
Home   >   mailing lists

Re: is it possible to recover more than one recordset or cursor from a function? - Mailing list pgsql-general

From Albe Laurenz
Subject Re: is it possible to recover more than one recordset or cursor from a function?
Date
Msg-id AFCCBB403D7E7A4581E48F20AF3E5DB2036897B0@EXADV1.host.magwien.gv.at
Whole thread Raw
In response to is it possible to recover more than one recordset or cursor from a function?  ("guillermo arias" <guillermoariast@linuxwaves.com>)
Responses Re: is it possible to recover more than one recordset or cursor from a function?
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: MC Moisei
Date:
Subject: Re: Ubuntu, Postgresql-8.2 and remote access thru pg_hba.conf
Next
From: "Pavel Stehule"
Date:
Subject: Re: is it possible to recover more than one recordset or cursor from a function?