Re: 'like' refuses to use an index???

From: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
To: <jks(at)selectacast(dot)net>
Cc: <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: 'like' refuses to use an index???
Date: 2004-01-01 18:21:49
Message-ID: 1091.62.156.29.168.1072981309.squirrel@new.host.name
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-01-01 18:52:42 Re: Mnogosearch (Was: Re: website doc search is ... )
Previous Message Tom Lane 2004-01-01 18:20:32 Re: Mnogosearch (Was: Re: website doc search is ... )