Re: like/ilike improvements

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: like/ilike improvements
Дата
Msg-id 465450DE.7020609@dunslane.net
обсуждение исходный текст
Ответ на Re: like/ilike improvements  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: like/ilike improvements  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Tom Lane wrote:
>
> 3. UTF8: % can advance bytewise.  _ must check it is on a first byte
> (else return match failure) and if so do NextChar.  So primitives
> are NextChar, NextByte, ByteEq, IsFirstByte.
>
>
>   

We should only be able to get out of step from the "%_" case, I believe, 
so we should only need to do the first-byte test in that case (which is 
in a different code path from the normal "_" case. Does that seem right?

cheers

andrew


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server
Следующее
От: Tom Lane
Дата:
Сообщение: Re: like/ilike improvements