Re: like/ilike improvements

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: like/ilike improvements
Дата
Msg-id 46562083.1080309@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:
> There should somewhere be a block comment explaining all the reasoning
> we've so painfully gone through about why the three cases (SB, MB, UTF8)
> are needed and how they must differ.
>
>             
>   

I'm working on a detailed description/rationale.

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? I 
don't mind keeping it and using it in Assert() though.

cheers

andrew


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Reviewing temp_tablespaces GUC patch
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: Reviewing temp_tablespaces GUC patch