4 ms·
> 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. M
by paulryanrogers 8y ago
> 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.
- cobythedog 8y agoThe current version (11) does: https://www.postgresql.org/docs/11/sql-createprocedure.html https://www.postgresql.org/docs/11/sql-createprocedure.html
- paulryanrogers 8y agoThat 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 https://github.com/okbob/plpsm0