PL/pgSQL

PL/pgSQL

PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural language supported by the PostgreSQL RDBMS. It closely resembles Oracle's PL/SQL language.

PL/pgSQL, as a fully featured programming language, allows much more procedural control than SQL, 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.

Игры ⚽ Поможем решить контрольную работу

Look at other dictionaries:

  • pgsql — PostgreSQL Datenbank, auch Installationspfadname (/usr/local/pgsql) …   Acronyms

  • pgsql — PostgreSQL Datenbank, auch Installationspfadname (/usr/local/pgsql) …   Acronyms von A bis Z

  • PL/pgSQL — (Procedural Language/PostGres Structured Query Language  процедурное расширение языка СУБД добавляет управляющие конструкции к стандарту SQL; допускает сложные вычисления; может использовать все объекты БД, определенные пользователем; прост в… …   Википедия

  • PL/PgSQL — (Procedural Language/PostgreSQL Structured Query Language) es un lenguaje imperativo provisto por el gestor de base de datos PostgreSQL. Permite ejecutar comandos SQL mediante un lenguaje de sentencias imperativas y uso de funciones, dando mucho… …   Wikipedia Español

  • PL/pgSQL — (Procedural Language/PostgreSQL Structured Query Language) est un langage procédural supporté par PostgreSQL. Il ressemble fortement au PL/SQL d Oracle. Portail des bases de données Ce document provient de « PL/pgSQL » …   Wikipédia en Français

  • PL/PgSQL — (Procedural Language/PostgreSQL Structured Query Language) es un lenguaje imperativo provisto por el gestor de base de datos PostgreSQL. Permite ejecutar comandos SQL mediante un lenguaje de sentencias imperativas y uso de funciones, dando mucho… …   Enciclopedia Universal

  • PostgreSQL — Developer(s) PostgreSQL Global Development Group Stable release 9.1.1[1] / 9.0.5 …   Wikipedia

  • Tom Lane (Open Source Software Developer) — Infobox Scientist name = Tom Lane birth date = birth date|1955|9|18 birth place = Madrid, Spain residence = U.S. nationality = field = Computer Science alma mater = Carnegie Mellon University known for = The Independent JPEG Group (IJG)… …   Wikipedia

  • PostgreSQL — Логотип PostgreSQL Тип Объектно реля …   Википедия

  • Sql — Содержание 1 История 1.1 Вопросы совместимости 2 Преимущества и недостатки …   Википедия

Share the article and excerpts

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