Skip site navigation (1) Skip section navigation (2)

pgsql: Improve match_special_index_operator() to recognize that LIKE

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Improve match_special_index_operator() to recognize that LIKE
Date: 2009-03-11 03:32:22
Message-ID: 20090311033222.C262F754AD4@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
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.

Modified Files:
--------------
    pgsql/src/backend/optimizer/path:
        indxpath.c (r1.237 -> r1.238)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/optimizer/path/indxpath.c?r1=1.237&r2=1.238)

pgsql-committers by date

Next:From: Andrew DunstanDate: 2009-03-11 03:33:29
Subject: pgsql: Use thread-local storage for querybuffer in fmtId() on Windows,
Previous:From: Alvaro HerreraDate: 2009-03-11 00:08:07
Subject: pgsql: Remove pg_trace.h inclusion from c.h and add it to the .c files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group