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

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: (When) can a single SQL statement return multiple result sets?
Дата
Msg-id 43e14d4d-6ed9-4140-a630-5a2b1d5a9d87@gmx.net
обсуждение исходный текст
Ответ на Re: (When) can a single SQL statement return multiple result sets?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: (When) can a single SQL statement return multiple result sets?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
Tom Lane schrieb am 11.04.2024 um 01:02:
> Jan Behrens <jbe-mlist@magnetkern.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"

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: (When) can a single SQL statement return multiple result sets?
Следующее
От: Andreas Wagner
Дата:
Сообщение: Re: Two server instances on one server