Re: LC_COLLATE and index usage

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: LC_COLLATE and index usage
Дата
Msg-id 20030508013011.G11722@hermes.hilbert.loc
обсуждение исходный текст
Ответ на LC_COLLATE and index usage  ("Forest Wilkinson" <lyris-pg@tibit.com>)
Ответы Re: LC_COLLATE and index usage  (Ralph Graulich <maillist@shauny.de>)
Список pgsql-general
> 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?
Question seconded (and tacit suggestion for a TODO item) on
behalf of GnuMed (www.gnumed.org).

Karsten Hilbert, MD
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


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

Предыдущее
От: Max Baker
Дата:
Сообщение: age() and date intervals
Следующее
От: dalgoda@ix.netcom.com (Mike Castle)
Дата:
Сообщение: Re: qsort (was Re: Solaris)