Re: [HACKERS] Stopgap solution for ILIKE in multibyte encodings

2006-09-04 Thread Tom Lane
"Guillaume Smet" <[EMAIL PROTECTED]> writes: > On 9/4/06, Tom Lane <[EMAIL PROTECTED]> wrote: >> I propose that for ILIKE in multibyte encodings, we just pass the strings >> through lower() and then use the normal LIKE code. > Perhaps it's a stupid question but what about the indexes? An index on

Re: [HACKERS] Stopgap solution for ILIKE in multibyte encodings

2006-09-04 Thread Guillaume Smet
Tom, On 9/4/06, Tom Lane <[EMAIL PROTECTED]> wrote: I propose that for ILIKE in multibyte encodings, we just pass the strings through lower() and then use the normal LIKE code. This will be a bit slower than what we do now, but as a wise man once said, code can be arbitrarily fast if it needn't