Re: SQL-Invoked Procedures for 8.1

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: SQL-Invoked Procedures for 8.1
Date: 2004-09-23 12:22:59
Message-ID: 4152C023.8060109@retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2004-09-23 12:39:11 Re: SQL-Invoked Procedures for 8.1
Previous Message Thomas Hallgren 2004-09-23 12:19:03 Re: Use of zlib