projects / postgresql.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 5049838) | patch
Make some improvements in the intelligence of the partial-index
authorTom Lane <[email protected]>
Wed, 7 Jan 2004 22:02:48 +0000 (22:02 +0000)
committerTom Lane <[email protected]>
Wed, 7 Jan 2004 22:02:48 +0000 (22:02 +0000)
commitcad5f4a8c4331153de9476a3dacd22577e358c39
treeccb7bdd35141d3097096dd0e2ba6f56df0fb1fd5tree
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 | blame | history
This is the main PostgreSQL git repository.