php-deluxe.net - description PL Perl

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 triggers or rules 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.rhtmlname=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]