projects / users / bernd / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4aa3563) | 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:43 +0000 (19:22 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 12 May 2007 19:22:43 +0000 (19:22 +0000)
commit0e8b2fd8c5a661ef8ec61336e349fd9fe012178a
tree819cd96a94c062ade37a3ced0a20c765a6f33571tree
parent4aa3563d023c610a3faa1c1f98f8eb5932b38d4ccommit | 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
Bernd Helmle's repository