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/
