Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux