Re: ilike not using index. - Mailing list pgsql-novice

Kenneth Marshall <ktm@rice.edu> writes:
> On Mon, Jun 21, 2010 at 03:36:07PM -0400, Tom Lane wrote:
>> You might consider creating an index on lower(full_name) and then
>> querying WHERE lower(full_name) LIKE whatever.

> Would citext support this?

No, unfortunately.  The index optimization for LIKE is hard-wired into
the planner, so it only supports built-in data types.  Someday it'd be
nice to have a way for add-on modules to insert that sort of
optimization.

            regards, tom lane