Improve match_special_index_operator() to recognize that LIKE with an
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 11 Mar 2009 03:32:22 +0000 (03:32 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 11 Mar 2009 03:32:22 +0000 (03:32 +0000)
commitb4df57ff9f4136e3e53be629d28187d38e416060
treea187eed4151bd9af0773b6b10fa49b0e460876ce
parentdcf3902f02db09a067f066bd46bc3ad354f323b9
Improve match_special_index_operator() to recognize that LIKE with an
exact-match pattern (no wildcard) can be index-optimized in some cases where a
prefix-match pattern cannot; specifically, since the required index clause is
simple equality, it works for regular text/varchar indexes even when the
locale is not C.  I'm not sure how often this case really comes up, but since
it requires hardly any additional work to handle it, we might as well get it
right.  Motivated by a discussion on the JDBC list.
src/backend/optimizer/path/indxpath.c