On Wed, Jul 1, 2020 at 5:58 AM Robert Haas <robertmh...@gmail.com> wrote: > On Tue, Jun 30, 2020 at 1:49 PM Peter Eisentraut > <peter.eisentr...@2ndquadrant.com> wrote: > > This adds support for writing CREATE FUNCTION and CREATE PROCEDURE > > statements for language SQL with a function body that conforms to the > > SQL standard and is portable to other implementations. > > With what other implementations is it compatible?
Judging by the Wikipedia article[1], it sounds like at least DB2 and MySQL/MariaDB are purposely striving for conformance. When I worked with DB2 a few years back I preferred to use their standard-conforming PL stuff (as opposed to their be-more-like-Oracle PL/SQL mode), and I always hoped that PostgreSQL would eventually understand the same syntax; admittedly, anyone who has ever worked on large applications that support multiple RDBMSs knows that there's more than just surface syntax to worry about, but it still seems like a pretty solid plan to conform to the standard that's in our name, so +1 from me on the general direction (I didn't look at the patch). [1] https://en.wikipedia.org/wiki/SQL/PSM