Re: returning multiple result sets from a stored procedure - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: returning multiple result sets from a stored procedure
Date
Msg-id 4C815567.70201@agliodbs.com
Whole thread Raw
In response to returning multiple result sets from a stored procedure  (John Adams <john_adams_mail@yahoo.com>)
Responses Re: returning multiple result sets from a stored procedure  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: returning multiple result sets from a stored procedure  (Merlin Moncure <mmoncure@gmail.com>)
OT: OFF TOPIC: returning multiple result sets from a stored procedure  (John Adams <john_adams_mail@yahoo.com>)
Re: returning multiple result sets from a stored procedure  (John Adams <john_adams_mail@yahoo.com>)
List pgsql-hackers
> I noticed in postgres you cannot return multiple result sets from a
> stored procedure (surprisingly as it looks like a very good dbms).

That feature has been on the TODO list for years.  However, nobody has
stepped forward to either write it, or to fund working on it.  If your
company has programmers or money to build this feature, it could
probably get done fairly quickly (as in, next version).

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: The other major HS TODO: standby promotion
Next
From: Robert Haas
Date:
Subject: Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)