On Thu, Sep 2, 2010 at 7:17 PM, Alvaro Herrera <alvhe...@commandprompt.com> wrote: > 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.
Also arrays can work pretty well, depending on how much data there is and where it's going. merlin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
