PL/pgSQL
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. 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.
- Abstraction100002137
- ArtificialLanguage106894544
- Code106355894
- CodingSystem106353757
- CommandLanguage106899446
- Communication100033020
- ComputerLanguage106899633
- DatabaseManagementSystem106588785
- language
- Language
- Language106282651
- ProgrammingLanguage
- ProgrammingLanguage106898352
- Q315
- Q9143
- Software106566077
- SourceLanguage106283912
- Thing
- WikicatComputerLanguages
- WikicatDatabaseManagementSystems
- WikicatProgrammingLanguages
- WikicatQueryLanguages
- Writing106359877
- WrittenCommunication106349220
- Comment
- enPL/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. 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.
- Depiction
- Designer
- enJan Wieck
- Developer
- enPostgreSQL Global Development Group
- Has abstract
- enPL/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. 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. 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 one of the programming languages included in the standard PostgreSQL distribution, the others being PL/Tcl, PL/Perl and PL/Python. In addition, many others are available from third parties, including PL/Java, PL/pgPSM, PL/php, PL/R, PL/Ruby, PL/sh, PL/Lua and PL/v8. PostgreSQL uses Bison as its parser,making it easy to port many open-source languages, as well as to reuse code.
- Homepage
- www.postgresql.org/docs/current/static/plpgsql.html
- Hypernym
- Language
- InfluencedBy
- Ada (programming language)
- SQL
- Influenced by
- Ada (programming language)
- SQL
- Is primary topic of
- pgSQL
- Label
- enPL/pgSQL
- Link from a Wikipage to an external page
- www.pgsql.cz/index.php/PL/pgSQL_%28en%29
- github.com/pllua/pllua
- www.postgresql.org/docs/current/static/plpgsql.html
- github.com/petere/plsh
- www.postgresql.org/docs/current/static/pltcl.html
- pgxn.org/dist/plv8/doc/plv8.html
- Link from a Wikipage to another Wikipage
- Ada (programming language)
- Category:Data-centric programming languages
- Category:PostgreSQL
- Category:SQL
- Code reuse
- Database trigger
- Document! X
- Documentation generator
- Doxygen
- File:Postgresql elephant.svg
- GNU bison
- Javadoc
- Natural Docs
- Open-source model
- Oracle Database
- ORDBMS
- PostgreSQL
- Procedural programming
- Programming language
- PSM
- ROBODoc
- SQL
- SQL
- Logo
- 120
- Name
- enPL/pgSQL
- Name
- enPL/pgSQL
- Page
- www.postgresql.org/docs/current/static/plpgsql.html
- Released
- 30 October 1998
- Release date
- 30 October 1998
- SameAs
- m.05967y
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- pgSQL
- PgSQL
- PLPGSQL
- Q2044345
- xKcY
- Subject
- Category:Data-centric programming languages
- Category:PostgreSQL
- Category:SQL
- Thumbnail
- WasDerivedFrom
- pgSQL?oldid=1122702605&ns=0
- Website
- plpgsql.html
- WikiPageLength
- 7427
- Wikipage page ID
- 1545014
- Wikipage revision ID
- 1122702605
- WikiPageUsesTemplate
- Template:Compu-lang-stub
- Template:Dunno
- Template:Infobox programming language
- Template:No
- Template:Reflist
- Template:Start date and age
- Template:Unsourced
- Template:Yes
