Re: LC_COLLATE and index usage - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: LC_COLLATE and index usage
Date
Msg-id 20030508013011.G11722@hermes.hilbert.loc
Whole thread Raw
In response to LC_COLLATE and index usage  ("Forest Wilkinson" <lyris-pg@tibit.com>)
Responses Re: LC_COLLATE and index usage
List 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 by date:

Previous
From: Max Baker
Date:
Subject: age() and date intervals
Next
From: dalgoda@ix.netcom.com (Mike Castle)
Date:
Subject: Re: qsort (was Re: Solaris)