PL/Perl

PL/Perl (Procedural Language/Perl) is a procedural language supported by the PostgreSQL RDBMS.

PL/Perl, as a true programming language, allows much more control than basic SQL, including the ability to use loops, advanced control structures, and quite sophisticated text manipulation. Programs created in the PL/Perl language are called functions, and can be called as part of a SQL statement, or as the action that a trigger or performs.

The design goals of PL/Perl were to create a loadable procedural language that:

* can be used to create functions and trigger procedures,
* adds control structures to the SQL language,
* can perform complex computations,
* can be defined to be either [http://www.postgresql.org/docs/current/static/plperl-trusted.html trusted or untrusted] by the server,
* is easy to use.

PL/Perl is one of many "PL" languages available for PostgreSQL
PL/pgSQL [http://gborg.postgresql.org/project/pljava/projdisplay.php PL/Java] , [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/list.rhtml?name=pl-ruby PL/Ruby] , [http://developer.postgresql.org/~petere/pgplsh/ PL/sh] , and [http://www.postgresql.org/docs/current/interactive/pltcl.html PL/Tcl] .

References

* [http://www.postgresql.org/docs/current/static/plperl.html PostgreSQL PL/Perl documentation]