projects / users / rhaas / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 9aa3c78) | patch
Improve predicate_refuted_by_simple_clause() to handle IS NULL and IS NOT NULL
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 May 2007 19:22:35 +0000 (19:22 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 May 2007 19:22:35 +0000 (19:22 +0000)
commit1856e609ec258ff25e371ca81cf18dc6abb415b9
tree6e49a2b38b1f7047b5307d758da65ff4f4405384tree
parent9aa3c782c939f29bd562a22030fb3a64e6f18365commit | diff
Improve predicate_refuted_by_simple_clause() to handle IS NULL and IS NOT NULL
more completely.  The motivation for having it understand IS NULL at all was
to allow use of "foo IS NULL" as one of the subsets of a partitioning on
"foo", but as reported by Aleksander Kmetec, it wasn't really getting the job
done.  Backpatch to 8.2 since this is arguably a performance bug.
src/backend/optimizer/util/predtest.c diff | blob | blame | history
Robert Haas's development tree.