Improve pull_up_subqueries logic so that it doesn't insert unnecessary

Tom Lane <tgl@sss.pgh.pa.us>

Commit: c59d8dd44d34ea617296b4a2d6e22fefc74593ed
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2009-04-28T21:31:16Z
Releases: 8.4.0
Improve pull_up_subqueries logic so that it doesn't insert unnecessary
PlaceHolderVar nodes in join quals appearing in or below the lowest
outer join that could null the subquery being pulled up.  This improves
the planner's ability to recognize constant join quals, and probably
helps with detection of common sort keys (equivalence classes) as well.

Files