PL/pgSQL
E97109
PL/pgSQL is PostgreSQL’s procedural extension of SQL that allows writing stored functions and triggers with control structures like variables, loops, and conditionals.
All labels observed (2)
| Label | Occurrences |
|---|---|
| PL/pgSQL canonical | 7 |
| Procedural Language/PostgreSQL Structured Query Language | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T816966 — resolving that mention is where its identity was fixed. The disambiguator weighed these candidate entities and picked the highlighted one (or “None”, minting a new entity). This is how homonymy is resolved: the same surface form can point to different entities.
NED1
Entity disambiguation (via context triple)
gpt-5-mini-2025-08-07
Target entity: PL/pgSQL Context triple: [PostgreSQL, supportsLanguage, PL/pgSQL]
-
A.
PostgreSQL
PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.
-
B.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
-
C.
DBE
DBE is the title "Dame Commander of the Order of the British Empire," a high-ranking honor awarded in the British honours system.
-
D.
IBM DB2
IBM DB2 is a family of enterprise-grade relational database management systems developed by IBM, widely used for high-performance, scalable data storage and transaction processing across mainframe, distributed, and cloud environments.
-
E.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
- F. None of above. chosen
- G. Unsure - the case is ambiguous/there is not enough information to decide.
NED2
Entity disambiguation (via description)
gpt-5-mini-2025-08-07
Target entity: PL/pgSQL Target entity description: PL/pgSQL is PostgreSQL’s procedural extension of SQL that allows writing stored functions and triggers with control structures like variables, loops, and conditionals.
-
A.
PostgreSQL
PostgreSQL is a powerful open-source relational database management system known for its robustness, extensibility, and strong standards compliance.
-
B.
SQL
SQL (Structured Query Language) is a standardized programming language used to manage, query, and manipulate data in relational database management systems.
-
C.
DBE
DBE is the title "Dame Commander of the Order of the British Empire," a high-ranking honor awarded in the British honours system.
-
D.
IBM DB2
IBM DB2 is a family of enterprise-grade relational database management systems developed by IBM, widely used for high-performance, scalable data storage and transaction processing across mainframe, distributed, and cloud environments.
-
E.
SQL Server
SQL Server is Microsoft's enterprise-grade relational database management system used for storing, managing, and analyzing data in a wide range of applications.
- F. None of above. chosen
Statements (70)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL extension
ⓘ
SQL extension ⓘ procedural programming language ⓘ |
| abbreviationOf |
Procedural Language/PostgreSQL Structured Query Language
ⓘ
linked to:
PL/pgSQL
|
| category |
database programming language
ⓘ
server-side scripting language ⓘ |
| designedFor | PostgreSQL ⓘ |
| developedFor | server-side programming ⓘ |
| documentationURL | https://www.postgresql.org/docs/current/plpgsql.html ⓘ |
| executionModel |
compiled to internal bytecode
ⓘ
executed inside PostgreSQL backend process ⓘ |
| hasSyntax |
BEGIN-END block
ⓘ
CREATE FUNCTION ⓘ DECLARE block ⓘ EXCEPTION block ⓘ |
| influencedBy |
Oracle PL/SQL
ⓘ
linked to:
PL/SQL
|
| integratedWith |
PostgreSQL query planner
ⓘ
PostgreSQL transaction manager ⓘ PostgreSQL type system ⓘ |
| languageName | PL/pgSQL ⓘ |
| primaryUse |
automation of database tasks
ⓘ
business logic in the database ⓘ data validation ⓘ |
| runsOn |
PostgreSQL server
ⓘ
linked to:
PostgreSQL
|
| supportsFeature |
AFTER triggers
ⓘ
BEFORE triggers ⓘ CASE statements ⓘ DEFAULT parameter values ⓘ FOR loops ⓘ FOREACH loops ⓘ IF statements ⓘ IMMUTABLE function attribute ⓘ INOUT parameters ⓘ INSTEAD OF triggers ⓘ NEW and OLD row references ⓘ OUT parameters ⓘ PERFORM statement ⓘ RAISE EXCEPTION ⓘ RAISE INFO ⓘ RAISE NOTICE ⓘ RAISE WARNING ⓘ RAISE statements ⓘ RETURN NEXT ⓘ RETURN QUERY ⓘ SECURITY DEFINER functions ⓘ SECURITY INVOKER functions ⓘ STABLE function attribute ⓘ STRICT option for functions ⓘ VOLATILE function attribute ⓘ WHILE loops ⓘ composite types ⓘ conditionals ⓘ control structures ⓘ cursors ⓘ dynamic SQL ⓘ exception handling ⓘ local variables ⓘ loops ⓘ named parameters ⓘ prepared statements ⓘ record types ⓘ row-level triggers ⓘ statement-level triggers ⓘ stored functions ⓘ stored procedures ⓘ transaction control ⓘ trigger functions ⓘ triggers ⓘ user-defined types ⓘ variables ⓘ |
How these facts were elicited
The pipeline generated the facts above by prompting gpt-5.1 with this entity's name + description and the instruction below.
Instruction
You are a knowledge base construction expert. Given a subject entity and a description of it, return factual statements that you know for the subject as a JSON list of dictionaries(triples), where keys must be "subject", "predicate" and "object". The number of facts may be very high, between 25 to 50 or more, for very popular subjects. For less popular subjects, the number of facts can be very low, like 5 or 10. # Requirements - If you don't know the subject at all, return an empty list. - If the subject is not a named entity, return an empty list. - Include at least one triple where predicate is "instanceOf". - Do not get too wordy. - Separate several objects into multiple triples with one object.
Input
Subject: PL/pgSQL Description of subject: PL/pgSQL is PostgreSQL’s procedural extension of SQL that allows writing stored functions and triggers with control structures like variables, loops, and conditionals.
Referenced by (8)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: PL/pgSQL