Re: dynamic result sets support in extended query protocol

On 01.02.22 15:40, Peter Eisentraut wrote:
> On 12.01.22 11:20, Julien Rouhaud wrote:
>> Since you mentioned that this patch depends on the SHOW_ALL_RESULTS 
>> psql patch
>> which is still being worked on, I'm not expecting much activity here 
>> until the
>> prerequirements are done.  It also seems better to mark this patch as 
>> Waiting
>> on Author as further reviews are probably not really needed for now.
> 
> Well, a review on the general architecture and approach would have been 
> useful.  But I understand that without the psql work, it's difficult for 
> a reviewer to even get started on this patch.  It's also similarly 
> difficult for me to keep updating it.  So I'll set it to Returned with 
> feedback for now and take it off the table.  I want to get back to it 
> when the prerequisites are more settled.

Now that the psql support for multiple result sets exists, I want to 
revive this patch.  It's the same as the last posted version, except now 
it doesn't require any psql changes or any weird test modifications anymore.

(Old news: This patch allows declaring a cursor WITH RETURN in a 
procedure to make the cursor's data be returned as a result of the CALL 
invocation.  The procedure needs to be declared with the DYNAMIC RESULT 
SETS attribute.)