projects / users / simon / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 62ac99a) | patch
Improve pull_up_subqueries logic so that it doesn't insert unnecessary
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 28 Apr 2009 21:31:16 +0000 (21:31 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 28 Apr 2009 21:31:16 +0000 (21:31 +0000)
commitdbbeb3a9541c068138a5eacb823ae1f4741900a8
treecf3350e7a6da471afd668e88a18c291955216e6ftree
parent62ac99ac5c5d82010ff6632d0fd9b72edc5a1241commit | diff
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.
src/backend/optimizer/plan/planner.c diff | blob | blame | history
src/backend/optimizer/prep/prepjointree.c diff | blob | blame | history
src/include/optimizer/prep.h diff | blob | blame | history
Simon's dev repository