News for hackers. Stuff that matters.

A comment on Common mistakes in PostgreSQL. Parent comment

Re:Common mistakes in PostgreSQL by paulryanrogers on Friday May 03, 2019 @10:01AM (#19818490)
> PostgreSQL is one of the databases that adheres the SQL standard most closely...

Minor nit, Pg doesn't have SQL standard stored procedures; a.k.a. SQL/PSM. Mysql and DB2 do however.

[ Parent | on HN ]
Re:Common mistakes in PostgreSQL by cobythedog on Friday May 03, 2019 @11:17AM (#19819162)
The current version (11) does: https://www.postgresql.org/docs/11/sql-createprocedure.html
[ Parent | on HN ]
Re:Common mistakes in PostgreSQL by paulryanrogers on Friday May 03, 2019 @06:02PM (#19822678)
That is the command to create one, but the syntax of the definition body is what does not comply with SQL/PSM.

Looks like there is an extension but it hasn't been updated in 8 years as doesn't appear to be production ready yet[0]

[0] https://github.com/okbob/plpsm0

[ Parent | on HN ]