- PL/pgSQL
PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural language supported by the
PostgreSQL RDBMS . It closely resembles Oracle'sPL/SQL language.PL/pgSQL, as a fully featured
programming language , allows much more procedural control thanSQL , including the ability to use loops and other control structures. Functions created in the PL/pgSQL language can be called from an SQL statement, or as the action that a trigger performs.PL/pgSQL was created to be able to perform more complex operations and computations than SQL, while being easy to use, and is able to be defined as trusted by the server. [citeweb| url = http://www.postgresql.org/docs/current/static/plpgsql.html | title = PL/pgSQL - SQL Procedural Language | accessdate = 2007-11-15]
PL/pgSQL is the only "PL" language installed by default for PostgreSQL, but many others are available, including [http://gborg.postgresql.org/project/pljava/projdisplay.php PL/Java] , [http://www.postgresql.org/docs/current/interactive/plperl.html PL/Perl] , [http://plphp.commandprompt.com/ plPHP] , [http://www.postgresql.org/docs/current/interactive/plpython.html PL/Python] , [http://www.joeconway.com/plr/ PL/R] , [http://raa.ruby-lang.org/project/pl-ruby PL/Ruby] , [http://plsh.projects.postgresql.org/ PL/sh] , and [http://www.postgresql.org/docs/current/interactive/pltcl.html PL/Tcl] .
References
Wikimedia Foundation. 2010.