Synonyms for pl_pgsql or Related words with pl_pgsql

perlscript              beanshell              jython              powershell              vbscript              jscript_vbscript              emacs_lisp              autohotkey              python_perl              gnu_aspell              tcl_tk              pythonscript              bytecode_interpreter              structured_query_language              autoit              javascript_javascript              php_perl              pl_sql              rdql              abap              xview              vb_net              perl_perl              jscript_net              python_scripting              jscript              php_python_ruby              perl_php              posix_threads              phpwiki              coldfusion_markup_language              pygtk              xotcl              oql              cfml              applescript              user_interface_markup_language              noweb              msvc              vbscript_jscript              javascript_jscript              qml              haxe              php_mysql              ispell              xpath_xquery              ddoc              xaml              nemerle              hypertalk             



Examples of "pl_pgsql"
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. SQL statements and triggers can call functions created in the PL/pgSQL language.
PL/pgSQL (Procedural Language/PostgreSQL) is a procedural programming language supported by the PostgreSQL ORDBMS. It closely resembles Oracle's PL/SQL language. Implemented by Jan Wieck, PL/pgSQL first appeared with PostgreSQL 6.4, released on October 30, 1998. Version 9 also implements some ISO SQL/PSM features, like overloading of SQL-invoked functions and procedures.
Formal pseud-language for documentation, can be embedded into SQL and PL/pgSQL scripts, and will be processed (documentation data-extraction and documentation hypertext generation) by an external tool, the documentation generator. Some of these tools have support to PL/SQL, so, it is expected to support also PL/pgSQL, in full or partial support.
All three languages (Oracle PL/SQL, PostgreSQL PL/pgSQL and ISO SQL/PSM) are originally descended from the Ada programming language.
Note (5): Materialized views are now standard but can be emulated in versions prior to 9.3 with stored procedures and triggers using PL/pgSQL, PL/Perl, PL/Python, or other procedural languages.
The design of PL/pgSQL aimed to allow Postgresql users to perform more complex operations and computations than SQL, while providing ease of use. The language is able to be defined as trusted by the server.
PL/pgSQL is the only programming language installed by default for PostgreSQL, but many others are available, including PL/Java, PL/Perl, PL/pgPSM, PL/php, PL/Python, PL/R, PL/Ruby,
The front end is written in Lua while the back end is written in PL/pgSQL. Both parts are released under the MIT License. There is also an API available which allows external applications to add additional features to the program.
PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language, which conforms to the ISO SQL’s SQL/PSM standard.
SQL/PSM resembles and inspired by PL/SQL, as well as PL/pgSQL, so they are similar languages. With PostgreSQL v9 some SQL/PSM features, like overloading of SQL-invoked functions and procedures are now supported. A PostgreSQL addon implements SQL/PSM (alongside its own procedural language), although it is not part of the core product.
The SQL/PSM language is specified by an ISO standard, but is also inspired by Oracle's PL/SQL and PL/pgPL/SQL, so there are few differences. The PL/pgPSM contributed module implements the standard. The main features of PSM that differ from PL/pgSQL:
xTuple uses the PostgreSQL database exclusively for storing and managing data. The GUI client relies heavily on PostgreSQL's native procedural language (PL/pgSQL) functions to process business logic, while the web client and node layers leverage additional capability made possible by the integration of Google's V8 JavaScript engine into the database using an extension known as PLV8. xTuple has written an Object-relational mapping system embedded in the database using JavaScript that processes all reads and transaction requests made via the NodeJS server.
The OpenMFG application make heavy use of Postgres' embedded procedural language, called PL/pgSQL. Whenever any kind of transaction is taking place in the system - a financial account being credited or debited, a piece of inventory being moved, or an order being taken - that is happening in a Postgres stored procedure, trigger, or function. This approach makes it relatively easy for other client software besides the OpenMFG graphical client to access business functionality. xTuple partners and customers have developed various alternative interfaces to access the Postgres backend database, including Web portals, wireless devices, and desktop office productivity software.
Triggers are fully supported and can be attached to tables. Triggers can be per-column and conditional, in that UPDATE triggers can target specific columns of a table, and triggers can be told to execute under a set of conditions as specified in the trigger's WHERE clause. Triggers can be attached to views by using the INSTEAD OF condition. Multiple triggers are fired in alphabetical order. In addition to calling functions written in the native PL/pgSQL, triggers can also invoke functions written in other languages like PL/Python or PL/Perl.