ProjectSet

Evaluates set-returning expressions in the target list for rows from its child.

Reading PG 18·Select a recorded version

Core node tag: T_ProjectSet
Structured EXPLAIN Node Type: ProjectSet
Inputs: One child plan
Output: Expanded result tuples
Executor initializer: ExecInitProjectSet
Memory mechanism: unclassified
evidence kind: source and documentation
explain names: ProjectSet
explain prefixes: Parallel, Async
node tag: T_ProjectSet
parallel callbacks: Unknown
partial modes: Unknown
runtime verified: false
strategies: Unknown

Definition PG 18

Evaluates set-returning expressions in the target list for rows from its child.

EXPLAIN labels in this source build

Text-format label	Structured node identity
ProjectSet	ProjectSet

Compare versions

Complete source facts

memory

{"description":"This extraction does not assign a universal memory limit or spill policy to this node. Inspect the same-build implementation and its expressions or provider.","evidence":[{"archive_sha256":"555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f","label":"src/backend/executor/nodeProjectSet.c","path":"src/backend/executor/nodeProjectSet.c","sha256":"86da5522860678066d56fcdc7fabd9b4dc96aac818665f3d3b039df5805a0595","url":"https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2"}],"mechanism":"unclassified","source_notes":[]}

source inventory

{"executor":"src/backend/executor/execProcnode.c","explain":"src/backend/commands/explain.c","implementation":"src/backend/executor/nodeProjectSet.c"}

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f