Tom M. Yeh wrote:
> Yes, it really depends on Locale. If I created a
> database with Locale = C, the problem won't happen (at
> least so far). BTW, I forgot to mention I tested with
> some Chinese and Japanese characters.
> However, it raises another issue why a wrong Locale
> would damage index? It shall only affect records with
> wrong conversion, not something like '1000'.
Search the list archives for LIKE and locale - different locales have
different sorting rules. Setting locale=C makes everything simple.
With 8.0 you can define your own operator classes to tell PG it can use
an index (see ch 11.6 of the manuals). I think there are examples in the
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2005-02-21 18:55:02|
|Subject: Re: BUG #1488: CREATE TABLESPACE does not work|
|Previous:||From: Tom M. Yeh||Date: 2005-02-21 16:39:59|
|Subject: Re: BUG #1487: Index problem|