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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | chelsea boot | 2006-06-15 11:22:49 | Replacing data |
Previous Message | willfarnaby | 2006-06-14 06:18:04 | Can PostgreSQL 8.x Return Multiple "Result Sets" ? |