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

From Alvaro Herrera
Subject Re: returning multiple result sets from a stored procedure
Date
Msg-id 1283469376-sup-7696@alvh.no-ip.org
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  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
Excerpts from John Adams's message of jue sep 02 18:25:45 -0400 2010:
> I noticed in postgres you cannot return multiple result sets from a stored 
> procedure (surprisingly as it looks like a very good dbms). 

If you're really intent about doing this, you can emulate it by
returning a set of refcursors.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: John Adams
Date:
Subject: returning multiple result sets from a stored procedure
Next
From: Fujii Masao
Date:
Subject: Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)