PL/Perl
E427687
PL/Perl is a procedural language extension for PostgreSQL that allows users to write database functions and triggers in the Perl programming language.
All labels observed (2)
| Label | Occurrences |
|---|---|
| PL/Perl canonical | 3 |
| Perl modules (with plperlu) | 1 |
How this entity was disambiguated
This entity first appeared as the object of triple T4279333 — 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/Perl Context triple: [PL/Tcl, relatedTo, PL/Perl]
-
A.
PL/Python
PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.
-
B.
PL/SQL
PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
-
C.
PL/pgSQL
PL/pgSQL is PostgreSQL’s procedural extension of SQL that allows writing stored functions and triggers with control structures like variables, loops, and conditionals.
-
D.
Programming Perl
Programming Perl is a comprehensive reference and tutorial book on the Perl programming language, co-authored by its creator Larry Wall and often regarded as the definitive guide for Perl programmers.
-
E.
PDL
PDL is a former name for USL League Two, a North American pre-professional soccer league that serves as a key development platform for college-aged and aspiring professional players.
- 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/Perl Target entity description: PL/Perl is a procedural language extension for PostgreSQL that allows users to write database functions and triggers in the Perl programming language.
-
A.
PL/Python
PL/Python is a procedural language extension for PostgreSQL that allows writing database functions and triggers in the Python programming language.
-
B.
PL/SQL
PL/SQL is Oracle's proprietary procedural extension to SQL, used for writing stored procedures, functions, and complex database logic within Oracle Database.
-
C.
PL/pgSQL
PL/pgSQL is PostgreSQL’s procedural extension of SQL that allows writing stored functions and triggers with control structures like variables, loops, and conditionals.
-
D.
Programming Perl
Programming Perl is a comprehensive reference and tutorial book on the Perl programming language, co-authored by its creator Larry Wall and often regarded as the definitive guide for Perl programmers.
-
E.
PDL
PDL is a former name for USL League Two, a North American pre-professional soccer league that serves as a key development platform for college-aged and aspiring professional players.
- F. None of above. chosen
Statements (49)
| Predicate | Object |
|---|---|
| instanceOf |
PostgreSQL extension
ⓘ
procedural language ⓘ server-side programming language ⓘ |
| allowsWriting |
database functions
ⓘ
stored procedures ⓘ triggers ⓘ |
| alternativeTo |
PL/Python
ⓘ
PL/Tcl ⓘ PL/pgSQL ⓘ |
| canCall | SQL commands via SPI ⓘ |
| canReturn |
composite types
ⓘ
scalar values ⓘ sets of rows ⓘ |
| category | PostgreSQL procedural languages ⓘ |
| codeStoredIn |
PostgreSQL system catalogs
ⓘ
linked to:
PostgreSQL
|
| designedFor | server-side Perl in PostgreSQL ⓘ |
| documentationSection | PostgreSQL PL/Perl documentation ⓘ |
| executionEnvironment | PostgreSQL server ⓘ |
| executionModel | interpreted ⓘ |
| hasUntrustedVariant | plperlu ⓘ |
| implementedAs | loadable module in PostgreSQL ⓘ |
| introducedIn | early PostgreSQL 7.x series (as a contrib language) ⓘ |
| invokedBy |
CREATE FUNCTION statements
ⓘ
CREATE TRIGGER statements ⓘ |
| isTrustedVariant | plperl ⓘ |
| languageFamily | Perl family ⓘ |
| maintainedBy | PostgreSQL Global Development Group ⓘ |
| requires |
Perl interpreter on server
ⓘ
PostgreSQL superuser to install language ⓘ |
| securityModel | trusted and untrusted variants ⓘ |
| supportsFeature |
Perl modules (with plperlu)
ⓘ
linked to:
PL/Perl
SPI (Server Programming Interface) ⓘ complex text processing ⓘ error handling ⓘ regular expressions ⓘ set-returning functions ⓘ trigger procedures ⓘ |
| supportsLanguage | Perl ⓘ |
| supportsVersion | multiple Perl versions depending on build ⓘ |
| trustedVariantRestrictions |
no direct access to operating system commands
ⓘ
no direct access to the file system ⓘ |
| typicalUseCase |
complex business logic in triggers
ⓘ
data validation ⓘ integration with existing Perl code (via plperlu) ⓘ text processing in database functions ⓘ |
| untrustedVariantCapabilities |
can access file system
ⓘ
can execute OS-level operations ⓘ can use arbitrary Perl modules ⓘ |
| usedWith | PostgreSQL ⓘ |
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/Perl Description of subject: PL/Perl is a procedural language extension for PostgreSQL that allows users to write database functions and triggers in the Perl programming language.
Referenced by (4)
Full triples — surface form annotated when it differs from this entity's canonical label.
linked to: PL/Perl