Hello 2008/10/15 Bruce Momjian <bruce@xxxxxxxxxx>: > 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@xxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
