Re: BUG #6642: Spanish collation fault

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.

In response to

Browse pgsql-bugs by date

  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