How to return result sets from a procedure in Postgres v12(beta).
The link below says that changes have been done in Postgres v12 beta.
□ Add support for polymorphic arguments and return types to languages other than PL/PgSQL
□ Add support for OUT and INOUT parameters to languages other than PL/PgSQL
□ Add more fine-grained specification of functions taking arbitrary data types
[D] ✓ Implement stored procedures
This might involve the control of transaction state and the return of multiple result sets
▪ PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
▪ Proposal: real procedures again (8.4)
▪ Gathering specs and discussion on feature (post 9.1)