From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | Tulio J Carrasco <tulio(dot)carrasco(at)gmail(dot)com> |
Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #6642: Spanish collation fault |
Date: | 2012-05-19 23:11:05 |
Message-ID: | 1337469065.10292.29.camel@vanquo.pezone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On ons, 2012-05-16 at 19:55 -0500, Tulio J Carrasco wrote:
> "León", "leon", "leOn" has identical order values: none of them
> weights more for Spanish collation and PG is not working according it
> if PG makes a "second pass" that ignores collation and reorders by its
> character value.
PostgreSQL uses the operating system's C library for sorting. Since you
are using Ubuntu, that is glibc for you. And a look into the glibc
sources shows that ó is sorted after o, the way Álvaro has explained.
If you disagree with that, you need to take it up with the glibc
maintainers.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-05-20 16:16:31 | Re: BUG #6651: macaddr length constraint violates standard |
Previous Message | Peter Eisentraut | 2012-05-19 22:56:57 | Re: BUG #6651: macaddr length constraint violates standard |