]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 4a898fb) | 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)
commit1e7f0c3a1428b89c2cd36140eb030927f68d1d47
tree7fe4475be7f99e22507bd42904eee334b4911a1ctree | snapshot
parent4a898fbb206f5fb93b4701f6f71d67715e6a1498commit | 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 | history
Unnamed repository; edit this file 'description' to name the repository.