Re: LIKE indexing proposal

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: LIKE indexing proposal
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961FA8@m0114.s-mxs.net
обсуждение исходный текст
Ответ на LIKE indexing proposal  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
> The objection last time was that, according to the SQL standard, LIKE
> patterns should use the locale-specific collation order for the fixed
> parts (instead of character-by-character comparisons),

Yes, I think that LIKE definitely needs to be character-by-character
and I can think of no example in the german language that would make
general sense (like ss and single byte sharp s (ß) would definitely be
nonsense if handled as equal for LIKE).

Andreas



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

Предыдущее
От: "Zeugswetter Andreas SB SD"
Дата:
Сообщение: Re: LIKE indexing proposal
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Scheduled jobs