Re: like/ilike improvements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: like/ilike improvements
Дата
Msg-id 8094.1180100538@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: like/ilike improvements  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
"Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at> writes:
>> You have to be on a first byte before you can meaningfully 
>> apply NextChar, and you have to use NextChar or else you 
>> don't count characters correctly (eg "__" must match 2 chars 
>> not 2 bytes).

> Well, for utf8 NextChar could advance to the next char even if the
> current byte
> position is in the middle of a multibyte char (skip over all 10xxxxxx). 

No doubt the macro could be made to work that way, but would it result
in correct matching behavior?  I doubt it --- you just matched an "_"
to half a character, or some such.
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: like/ilike improvements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: like/ilike improvements