Re: LIKE optimization and locale

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: LIKE optimization and locale
Дата
Msg-id Pine.LNX.4.21.0011261059290.764-100000@peter.localdomain
обсуждение исходный текст
Ответ на LIKE optimization and locale  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: LIKE optimization and locale  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Bruce Momjian writes:

> Why don't we just spin through all 255 locale values, and find the
> lowest value that is greater than comparison target.

The issue is not that the 255 extended ASCII characters have a different
ordering in various locales (although that's part of it).  The real
problem lies with multi-character collating elements, context dependent
collation order, multi-pass sorting algorithms, etc.  I'm almost convinced
that it is not possible to do any such optimization as we had for the most
general case.

-- 
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/



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

Предыдущее
От: Alain Toussaint
Дата:
Сообщение: Re: Re: [NOVICE] Re: re : PHP and persistent connections
Следующее
От: Cyril VELTER
Дата:
Сообщение: Re: Proposal for fixing IPC key assignment