Feedback-ID: ie0a040ee:Fastmail
Message-ID: <9ef79e99-fc9c-4328-b272-31d9011734a4@eisentraut.org>
Date: Mon, 15 Apr 2024 16:55:43 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: (When) can a single SQL statement return multiple result sets?
To: Tom Lane <tgl@sss.pgh.pa.us>, Jan Behrens <jbe-mlist@magnetkern.de>
Cc: pgsql-general@lists.postgresql.org
References: <20240410232247.b48cdf2677f87d37b167e140@magnetkern.de>
 <7504.1712790168@sss.pgh.pa.us>
Content-Language: en-US
From: Peter Eisentraut <peter@eisentraut.org>
In-Reply-To: <7504.1712790168@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/9ef79e99-fc9c-4328-b272-31d9011734a4%40eisentraut.org>
Precedence: bulk

On 11.04.24 01:02, Tom Lane wrote:
>> And if not, why can't I write a stored procedure
>> or function that returns multiple result sets?
> 
> [ shrug... ] Lack of round tuits, perhaps.  We don't have any
> mechanism today whereby a stored procedure could say "please ship
> this resultset off to the client, but I want to continue afterwards".
> But you can do that in other RDBMSes and probably somebody will be
> motivated to make it possible in Postgres.

The development of this feature was the subject of this thread: 
https://www.postgresql.org/message-id/flat/6e747f98-835f-2e05-cde5-86ee444a7140@2ndquadrant.com

But it has not concluded successfully yet.