News for hackers. Stuff that matters.

A comment on Common mistakes in PostgreSQL. Parent comment

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 ]