Re: index returns different output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: index returns different output
Дата
Msg-id 24474.973385111@sss.pgh.pa.us
обсуждение исходный текст
Ответ на index returns different output  (Viktor Przebinda <viktor@solon.Colorado.EDU>)
Список pgsql-bugs
What LOCALE setting do you run the postmaster in?

This looks like it might be the known problem with LIKE index
optimization not coping very well with non-ASCII collation orders.
(It tries, but if you have collation rules where multicharacter
patterns are treated specially, it tends to do the wrong thing...)

You can find lots of discussion about this in the pgsql mailing
list archives.  I don't think anyone's worked out a complete solution
short of not doing the optimization at all in non-ASCII locales :-(

            regards, tom lane

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

Предыдущее
От: Viktor Przebinda
Дата:
Сообщение: index returns different output
Следующее
От: Tom Lane
Дата:
Сообщение: Re: index returns different output