LC_COLLATE and index usage

Поиск
Список
Период
Сортировка
According to the postgres 7.3.2 docs, initializing a database cluster
with LC_COLLATE set to anything other than "C" will disable the use of
indexes during LIKE searches.  This presents a bit of a problem for
me, since the client application I'm writing uses LIKE searches and
ships internationally.  As I understand it, I can have good
performance, or locale-specific ORDER BY output, but not both.  Is
there a plan to remove this limitation?


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

Предыдущее
От: eruqamca@yahoo.com (jose arias)
Дата:
Сообщение: bpchar_name
Следующее
От: "Forest Wilkinson"
Дата:
Сообщение: How to determine a database cluster's LC_COLLATE setting?