Re: LIKE on index not working

Am Donnerstag, 22. Juli 2004 09:38 schrieb Chris Cox:
> For some reason I just can't get this to use the index for the following
> query.  I'm using PostgreSQL 7.3.4.

In 7.3, LIKE cannot use an index unless you set the locale to C.  In 7.4, LIKE 
can use an index, but it has to be a different kind of index, as explained 
here:

http://www.postgresql.org/docs/7.4/static/indexes-opclass.html

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/