Skip site navigation (1) Skip section navigation (2)

Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ?

From: david(at)fetter(dot)org (David Fetter)
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Can PostgreSQL 8.x Return Multiple "Result Sets" ?
Date: 2006-06-15 00:58:09
Message-ID: 6uednVBaUJk8LQ3ZnZ2dnUVZ_oednZ2d@speakeasy.net (view raw or flat)
Thread:
Lists: pgsql-novice
willfarnaby <willfarnaby(at)hotmail(dot)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(at)fetter(dot)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

In response to

pgsql-novice by date

Next:From: chelsea bootDate: 2006-06-15 11:22:49
Subject: Replacing data
Previous:From: willfarnabyDate: 2006-06-14 06:18:04
Subject: Can PostgreSQL 8.x Return Multiple "Result Sets" ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group