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
|
| Список | 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 по дате отправления: