LC_COLLATE and index usage

Поиск
Список
Период
Сортировка
Искать
От
Forest Wilkinson
Тема
LC_COLLATE and index usage
Дата
в 18:34:40
Msg-id
k71jbvo3j70mbdfpumf25r95qt9a2vm7kr@4ax.com
Список
Дерево обсуждения
Re: LC_COLLATE and index usage Dennis Gearon <gearond@cvc.net>
Re: LC_COLLATE and index usage Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: LC_COLLATE and index usage Alvaro Herrera <alvherre@dcc.uchile.cl> 
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
Дата:
FAQ