From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: index for ilike operation |
Date: | 2011-02-08 05:26:07 |
Message-ID: | 4D50D3EF.9000202@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 please tell me how to configure that?/
> /
hmm? nothing to configure. its a special case thats really not very
useful.
WHERE something ILIKE '432432$#(at)$#%'
would use a index on something, since there's no characters in there
subject to case shifting.
ditto...
WHERE something ~* '^42432$(at)#$#@' (where ^ anchors the string
to match starting from the first char)
From | Date | Subject | |
---|---|---|---|
Next Message | Niklas Langvig | 2011-02-08 08:01:38 | Question about database configuration |
Previous Message | AI Rumman | 2011-02-08 05:07:25 | index for ilike operation |