Jump to letter: [
CDGILMOPRSTU
]
plpgpsm - Implementation of SQL/PSM language for PostgreSQL
- Description:
In 1998 a draft of the new standard became part of SQL3 - under the
name SQL/PSM (ANSI/ISO/IEC 9075-4:1999). Unfortunately at that time
most big companies had their own languages (incompatible with the
standard) and refused to abandon them in favor of standard. SQL/PSM
was implemented only in those RDBMS, in which there was no support for
stored procedures before 1998. Except for DB2 (SQL PL, IBM, 2001) all
of them were minor RDBMS: Miner, Solid, 602SQL Server. After 2005 the
SQL/PSM standard started to become more popular, when it was
implemented in Advantage Database Server (Sybase iAnywhere, 2005),
MySQL (2005) and PostgreSQL (2007). Implementation of SQL/PSM is
usually incomplete, SQL PL in DB2 is considered to be one of the best
implementations. PostgreSQL implementation is called PL/pgPSM (using
the standard naming scheme in PostgreSQL).
Packages