Home > mailing lists

index for ilike operation - Mailing list pgsql-general

From	AI Rumman
Subject	index for ilike operation
Date	February 8, 2011 04:07:34
Msg-id	AANLkTi=nB0HH_c2+WBZ-9ByaozQTqiF2Oq37XPKd8BJ6@mail.gmail.com Whole thread Raw
Responses	Re: index for ilike operation
List	pgsql-general

Tree view

I found that in Postresql 9.0.3 documentation:

It is also possible to use B-tree indexes for ILIKE and ~*, but only if the pattern starts with non-alphabetic characters, i.e., characters that are not affected by upper/lower case conversion.

Can anyone please tell me how to configure that?

pgsql-general by date:

From: Vinubalaji Gopal
Date: 07 February 2011, 23:43:11
Subject: Re: tuning postgresql writes to disk

From: John R Pierce
Date: 08 February 2011, 04:26:25
Subject: Re: index for ilike operation

index for ilike operation - Mailing list pgsql-general

Previous

Next