Postgres Pro
Downloads
Home   >   mailing lists

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

From Joseph Shraibman
Subject Re: 'like' refuses to use an index???
Date
Msg-id 3FF36221.1090300@selectacast.net
Whole thread Raw
In response to Re: 'like' refuses to use an index???  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 'like' refuses to use an index???  ("Peter Eisentraut" <peter_e@gmx.net>)
List pgsql-general
Tree view 
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?  Is it automatic for text fields?

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: website doc search is extremely SLOW
Next
From: "Marc G. Fournier"
Date:
Subject: Re: website doc search is extremely SLOW