Quick Links

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

From:	Joseph Shraibman <jks(at)selectacast(dot)net>
To:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:	PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject:	Re: 'like' refuses to use an index???
Date:	2003-12-31 23:56:17
Message-ID:	3FF36221.1090300@selectacast.net
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

In response to

Re: 'like' refuses to use an index??? at 2003-12-30 22:06:59 from Tom Lane

Responses

Re: 'like' refuses to use an index??? at 2004-01-01 18:21:49 from Peter Eisentraut

Browse pgsql-general by date

	From	Date	Subject
Next Message	Marc G. Fournier	2004-01-01 00:40:22	Re: website doc search is extremely SLOW
Previous Message	Bruce Momjian	2003-12-31 23:43:51	Re: website doc search is extremely SLOW