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

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.

--
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. +