Hannu Krosing wrote:
>On N, 2004-09-23 at 11:34, Grant Finnemore wrote:
>
>
>>Hi Magnus,
>>
>>Yes, this is the situation that I have been thinking about. Specifically
>>when a single stored procedure returns many recordsets.
>>
>>
>
>IIRC support for returning multiple recordsets was removed from
>postgresql fe-be protocol years ago as "nobody ever needs it" ;)
>
>
Until recently I would have said the same thing.
A couple of months ago I started a new job where they are MS-SQL based,
and they do have several procedures that actually do return multiple
recordsets from a single procedure. However this is the only time that
I've ever seen any procedure actually require it.
Peter