Re:PostgreSQL’s New LATERAL Join Type
by nunwuo on Tuesday December 02, 2014 @05:45PM
(#8690549)
There's no faith required; the planner is guaranteed not to do that. The "normal" way is to create a composite type containing each of the columns you need, and then "unpack" it to separate columns. Horrible? Yeah, but it's possible.
[ Parent
| on HN ]
Re:PostgreSQL’s New LATERAL Join Type
by bchallenor on Tuesday December 02, 2014 @06:10PM
(#8690725)
Is it possible with scalar subqueries to perform anything other than a tree of correlation? With CROSS APPLY one can correlate a DAG of subqueries, e.g. a diamond where B and C depend on A, and D depends on B and C.