Re: like/ilike improvements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: like/ilike improvements
Дата
Msg-id 28377.1180056379@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: like/ilike improvements  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: like/ilike improvements  (Andrew Dunstan <andrew@dunslane.net>)
Re: like/ilike improvements  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> However, I have just about convinced myself that we don't need 
> IsFirstByte for matching "_" for UTF8, either preceded by "%" or not, as 
> it should always be true. Can anyone come up with a counter example?

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).
        regards, tom lane


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

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