Re: (When) can a single SQL statement return multiple result sets?

From: Thomas Kellerer <shammat(at)gmx(dot)net>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: (When) can a single SQL statement return multiple result sets?
Date: 2024-04-11 05:25:59
Message-ID: 43e14d4d-6ed9-4140-a630-5a2b1d5a9d87@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane schrieb am 11.04.2024 um 01:02:
> Jan Behrens <jbe-mlist(at)magnetkern(dot)de> writes:
>> While writing a PostgreSQL client library for Lua supporting
>> Pipelining (using PQsendQueryParams), I have been wondering if there
>> are any single SQL commands that return multiple result sets.
>
> Right now, I don't think so.

Hmm, what about functions returning multiple refcursors?

From a client library point of view, I think that would qualify as
"multiple result sets"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Wagner 2024-04-11 07:07:08 Re: Two server instances on one server
Previous Message Tom Lane 2024-04-10 23:02:48 Re: (When) can a single SQL statement return multiple result sets?