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

Hello

2008/10/15 Bruce Momjian <bruce@momjian.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@momjian.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>