Re: Postgres 11 procedures and result sets

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