News for hackers. Stuff that matters.
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.
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.