Re: SQL-Invoked Procedures for 8.1

On N, 2004-09-23 at 15:22, Peter Mount wrote:
> 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.

Actually the original support was inhetited from Postgres4.2 where
PostQuel had native support for it.

It was probably decided that SQL (which replaced PostQuel) would not
generate such things.

------------
Hannu