Re: Postgres 11 procedures and result sets

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgres 11 procedures and result sets
Дата
Msg-id 4493.1538438228@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgres 11 procedures and result sets  (Jan Kohnert <nospam001-lists@jan-kohnert.de>)
Ответы Re: Postgres 11 procedures and result sets  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-general
Jan Kohnert <nospam001-lists@jan-kohnert.de> writes:
> I have a question regarding the new stored procedures in Postgres 11 (I tested
> beta4):
> I'd like to know if it is somehow possible to get a (or possibly more) result
> set from selects within the SP, as it is possible in MariaDB, MySQL, or SQL
> Server.

Not there as of v11, other than the refcursor approach you already know
about.  We hope to have something nicer worked out for v12.  There
are a lot of compatibility issues to sort through :-(

            regards, tom lane


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

Предыдущее
От: derek
Дата:
Сообщение: Re: CREATE TABLE AS SELECT hangs
Следующее
От: Harry B
Дата:
Сообщение: Postgres 11, partitioning with a custom hash function