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 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]


Wikimedia Foundation. 2010.

Игры ⚽ Поможем написать курсовую

Look at other dictionaries:

  • PERL — Paradigmen: prozedural, modular, teilweise objektorientiert Erscheinungsjahr: 1987 Entwickler: Larry Wall, Perl Porter Aktuelle  …   Deutsch Wikipedia

  • Perl (Programmiersprache) — Perl Paradigmen: prozedural, modular, teilweise objektorientiert Erscheinungsjahr: 1987 Entwickler: Larry Wall, Perl Porter Aktuelle Version …   Deutsch Wikipedia

  • Perl — Desarrollador(es) Larry Wall www.perl.org Información general Paradigma multiparadigma, funcional, im …   Wikipedia Español

  • Perl 6 — Apparu en Spécification : 2001 2011, mise en œuvre partielle par Rakudo Star Auteur …   Wikipédia en Français

  • Perl 6 — Saltar a navegación, búsqueda Perl 6 Paradigma: multiparadigma Apareció en: 2000 Diseñado por: Larry Wall y la comunidad Perl Tipo de dato: Dinámico y estático Implementaciones …   Wikipedia Español

  • Perl — Семантика: мультипарадигменный: императивный, объектно ориентированный, функциональный Тип исполнения: интерпретатор Появился в: 1987 Автор(ы) …   Википедия

  • Perl 5 — Perl (langage) Pour les articles homonymes, voir Perl. Apparu en 1987 …   Wikipédia en Français

  • Perl Compatible Regular Expressions — Original author(s) Philip Hazel Stable release 8.20 / 2011 10 21; 25 days ago (2011 10 21) Written in C …   Wikipedia

  • Perl Mongers — is part of The Perl Foundation and provides services to Perl user groups. Perl Mongers was created in 1998 as a stand alone organization by Brian D Foy who formed the first Perl users group, the New York Perl Mongers, or NY.pm, in 1997 at the… …   Wikipedia

  • Perl 6 — Класс языка: Мультипарадигмальный Появился в: 2000 …   Википедия

  • PERL, JOSEPH — (1773–1839), author of significant satirical works and leading figure in the Galician haskalah . Perl was born in Tarnopol, where he spent most of his life. In his youth he was attracted to Ḥasidism and acquired knowledge of the movement s way of …   Encyclopedia of Judaism

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”