[prev] [index] [next]

PLpgSQL

PLpgSQL = Procedural Language extensions to PostgreSQL

A PostgreSQL-specific language integrating features of:

  • procedural programming and SQL programming
Functions are stored in the database with the data.

Provides a means for extending DBMS functionality, e.g.

  • implementing constraint checking (triggered functions)
  • complex query evaluation (e.g. recursive)
  • complex computation of column values
  • detailed control of displayed results