Re: [GENERAL] index for ilike operation

2011-02-07 Thread John R Pierce
On 02/07/11 9:07 PM, AI Rumman wrote: 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

[GENERAL] index for ilike operation

2011-02-07 Thread AI Rumman
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?* *