Re: Re: multi recordset and data type check was: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?

Added to TODO:

Add support for returning multiple result sets?

* http://archives.postgresql.org/pgsql-general/2008-10/msg00454.php

---------------------------------------------------------------------------

Pavel Stehule wrote:
> Hello
>
> 2008/10/15 Bruce Momjian <bruce(at)momjian(dot)us>:
> > Vladimir Dzhuvinov wrote:
> > -- Start of PGP signed section.
> >> Hi Ivan,
> >>
> >> > It seems anyway that the usefulness of this feature largely depends
> >> > on the language library.
> >> > eg. I can't see a way to support it with php right now but it is
> >> > supported by python.
> >> > Am I missing something?
> >>
> >> Yes, the client library will have to support multiple result sets too.
> >>
> >> For example, the PHP MySQLi lib does that by providing functions to
> >> check for and retrieve outstanding result sets in the buffer:
> >>
> >> bool mysqli_more_results ($link)
> >>
> >> bool mysqli_next_result ($link)
> >>
> >>
> >> It seems like the PHP PG binding does allow (?) retrieval of multiple
> >> result sets through pg_get_result(), but only for requests issued
> >> asynchronously:
> >>
> >> http://bg2.php.net/manual/en/function.pg-get-result.php
> >>
> >>
> >> > Out of curiosity, what language are you using?
> >>
> >> For MySQL I've been mostly using PHP, occasionally Java, Python and C.
> >
> > Interesting. I think we need to decide if we want a TODO for this.
> >
>
> year ago I wrote prototype:
> http://okbob.blogspot.com/2007/11/stacked-recordset-multirecordset.html
> http://okbob.blogspot.com/2007/11/first-real-procedures-on-postgresql.html
>
> regards
> Pavel Stehule
>
>
> > --
> > Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
> > EnterpriseDB http://enterprisedb.com
> >
> > + If your life is a hard drive, Christ can be your backup. +
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
> >

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +