Editing PL/pgSQL (section)

== Comparing with PSM ==
The [[SQL/PSM]] language is specified by an ISO standard, but is also inspired by Oracle's PL/SQL and PL/pgPL/SQL, so there are few differences.  The PL/pgPSM contributed module implements the standard.  The main features of PSM that differ from PL/pgSQL:<ref name = PSM /><ref name = proposal>{{Citation | title=Hackers | type = mailing list | publisher = PostgreSQL | contribution-url = https://www.postgresql.org/message-id/CAFj8pRDWFdcjNSnwQB_3j1-rMO6b8=TmLTNBvDCSpRrOW2Dfeg@mail.gmail.com | contribution = Proposal: PL/pgPSM for pg9.3 | first = P | last = Stehule}}.</ref>

* Exception handlers are subroutines (continue handlers);
* Warnings can be handled as an exception;
* Declaration of variables should be based on SQL query results.

All three languages (Oracle PL/SQL,<ref>{{Citation | series = Database Online Documentation | edition = 11g Release 1 (11.1) | title = PL/SQL Language Reference | page = 87 | chapter = C. PL/SQL Program Limits | publisher = Oracle | chapter-url = http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/limits.htm#LNPLS018 | quote = PL/SQL is based on the programming language Ada.}}</ref> PostgreSQL PL/pgSQL and ISO SQL/PSM<ref>{{Citation | title = Stored procedures | chapter = 1 | publisher = O’Reilly | format = [[Open document presentation|ODP]] | url = http://cdn.oreillystatic.com/en/assets/1/event/36/Stored%2520Procedures%2520-%2520Part%25201%2520Presentation.odp}}.</ref>) were heavily influenced by the [[Ada (programming language)|Ada programming language]].