In PostgreSQL 11 beta1 announcement, it is stated that a major feature of the new version is
SQL Stored Procedures
PostgreSQL 11 introduces SQL stored procedures that allow users to use embedded transactions (i.e. BEGIN, COMMIT/ROLLBACK) within a procedure. Procedures can be created using the CREATE PROCEDURE command and executed using the CALL command.
My questions are,
From browsing the two documentation page, they seem to be quite similar and can both ,e.g., take parameters and return
OUTvalues. Is transaction behavior the only difference?
I have written many functions in PL/PGSQL. Should I change my functions to the new procedures? (If so, what are the advantages?)