]> granicus.if.org Git - postgresql/commit
projects / postgresql / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5049838) | patch
Make some improvements in the intelligence of the partial-index
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 7 Jan 2004 22:02:48 +0000 (22:02 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 7 Jan 2004 22:02:48 +0000 (22:02 +0000)
commitcad5f4a8c4331153de9476a3dacd22577e358c39
treeccb7bdd35141d3097096dd0e2ba6f56df0fb1fd5tree | snapshot
parent504983859d86549dd0a41462869be83af78af6f8commit | diff
Make some improvements in the intelligence of the partial-index
predicate tester.  It can now deal with commuted clauses (for
instance, 4 < x implies x > 3), subclauses more complicated than
a simple Var (for example, upper(x) = 't' implies upper(x) > 'a'),
and <> operators (for example, x < 3 implies x <> 4).  Still
only understands operators associated with btree opclasses, though.
Inspired by example from Martin Hampl.
src/backend/optimizer/path/indxpath.c diff | blob | history
Unnamed repository; edit this file 'description' to name the repository.