Thread

Re: SQL-Invoked Procedures for 8.1

Peter Mount <peter@retep.org.uk> — 2004-09-23T12:22:59Z

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