Re: 'like' refuses to use an index??? - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: 'like' refuses to use an index???
Date
Msg-id 1091.62.156.29.168.1072981309.squirrel@new.host.name
Whole thread Raw
In response to Re: 'like' refuses to use an index???  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman writes:
> Tom Lane wrote:
>> BTW, 7.4 also has a specialized index opclass that can be used to
>> create LIKE-compatible indexes even if you are using a non-C locale.
>>
> Where is that documented?

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

> Is it automatic for text fields?

No.




pgsql-general by date:

Previous
From: "Peter Eisentraut"
Date:
Subject: Re: Binaries (rpm) for SuSE 9.0...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Mnogosearch (Was: Re: website doc search is ... )