SQL/PSM

From Seo Wiki - Search Engine Optimization and Programming Languages

Jump to: navigation, search

SQL/PSM stands for Structured Query Language/Persistent Stored Modules, and was developed by the American National Standards Institute (ANSI) as an extension to SQL.[1] It was first adopted in 1996,[2] and it provides procedural programmability in addition to the querying commands of SQL.

The SQL/PSM extension is defined by ISO/IEC 9075-4:2003. SQL/PSM standardizes procedural extensions for SQL, including flow of control, condition handling, statement condition signals and resignals, cursors and local variables, and assignment of expressions to variables and parameters. In addition, SQL/PSM formalizes declaration and maintenance of persistent database language routines (e.g., "stored procedures").

See also

References

  1. NIST Article
  2. DBMS Magazine

External links

Some samples of SQL/PSM functions - http://www.pgsql.cz/index.php/SQL/PSM_Manual

ru:SQL/PSM
Personal tools

Served in 0.096 secs.