Re: Bug in ILIKE? - Mailing list pgsql-hackers

Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.net> writes:
>   
>> Tom Lane wrote:
>>     
>>> I think it's just a bug in 8.3.
>>>       
>
>   
>> Well, here's a patch that I think fixes it. If you're happy I'll apply 
>> it to HEAD and 8.3.
>>     
>
> That patch isn't gonna apply to HEAD ;-).  Also the introduction of
> NextChar is simply broken, as it will skip additional bytes of a
> multibyte char without having compared 'em.  All you need AFAICS is
> to put TCHAR()s into the *p != *t comparison, so that it matches the
> case for ordinary characters.
>
>             
>   

I'll have another look. What happens in that case though if you have 
escape+x where x is a multibyte char?

cheers

andrew