PostgreSQL Internal Subquery Resolution Process
Query Structure
SELECT val FROM (SELECT val FROM source_table);
Internal Representation
The derived clause FROM (SELECT val FROM source_table) generates a RangeTblEntry for the enclosing query.
The base relation source_table generates a separate RangeTblEntry inside the nested query.
All RangeTblEntry instances form a range table list, linke ...
Posted on Thu, 11 Jun 2026 18:24:16 +0000 by Gump