Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ? - Mailing list pgsql-novice

From david@fetter.org (David Fetter)
Subject Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ?
Date
Msg-id 6uednVBaUJk8LQ3ZnZ2dnUVZ_oednZ2d@speakeasy.net
Whole thread Raw
In response to Can PostgreSQL 8.x Return Multiple "Result Sets" ?  ("willfarnaby" <willfarnaby@hotmail.com>)
List pgsql-novice
willfarnaby <willfarnaby@hotmail.com> wrote:
> Can PostgreSQL 8.x Return Multiple "Result Sets" and, if so, can
> someone in the know provide or at least sketch the equivalent of the
> SQL Server stored proc listed below?

Essentially, yes.  You can return a row containing some fixed number
of REFCURSORs, or if you don't know in advance how many you'll get,
you can make a set-returning function that returns them one at a time
until done.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Courage is the first of human qualities because it is the quality
which guarantees all others.
                                                Winston Churchill

pgsql-novice by date:

Previous
From: "willfarnaby"
Date:
Subject: Can PostgreSQL 8.x Return Multiple "Result Sets" ?
Next
From: Charlie
Date:
Subject: cannot access directory /pg_tblspc/*