PL/Perl
From Wikipedia, the free encyclopedia
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 rule 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 trusted or untrusted by the server,
- is easy to use.
PL/Perl is one of many "PL" languages available for PostgreSQL PL/pgSQL PL/Java, plPHP, PL/Python, PL/R, PL/Ruby, PL/sh, and PL/Tcl.
