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

From Pavel Stehule
Subject Re: multi recordset and data type check was: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Date
Msg-id 162867790810130616s11eb08bqb67b694af910b4df@mail.gmail.com
Whole thread Raw
In response to Re: multi recordset and data type check was: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Hello

2008/10/13 Ivan Sergio Borgonovo <mail@webthatworks.it>:
> On Mon, 13 Oct 2008 15:19:33 +0300
> Vladimir Dzhuvinov <vd@valan.net> wrote:
>
>> Well, (in MySQL at least) in that case you're still going to get a
>> result set, it's just going to be an empty one (result with no
>> rows).
>
>> So, no matter how many rows the SELECT statements resolve to,
>> you're always going to get two result sets :)
>
> 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?
>
> Out of curiosity, what language are you using?

I know so multirecordsets are well supported for php and MySQL, and in
all Microsoft environments - Microsoft SQL Server use it very hard.
These functionality has lot of advantage, mainly in stateless
environment like plpgsql.

regards
Pavel Stehule

>
> --
> Ivan Sergio Borgonovo
> http://www.webthatworks.it
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

pgsql-general by date:

Previous
From: ries van Twisk
Date:
Subject: Re: Drupal and PostgreSQL - performance issues?
Next
From: justin
Date:
Subject: Re: Chart of Accounts