Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres 11 procedures and result sets - Mailing list pgsql-general

From Tom Lane
Subject Re: Postgres 11 procedures and result sets
Date
Msg-id 4493.1538438228@sss.pgh.pa.us
Whole thread Raw
In response to Postgres 11 procedures and result sets  (Jan Kohnert <nospam001-lists@jan-kohnert.de>)
Responses Re: Postgres 11 procedures and result sets  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: derek
Date:
Subject: Re: CREATE TABLE AS SELECT hangs
Next
From: Harry B
Date:
Subject: Postgres 11, partitioning with a custom hash function