Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6642: Spanish collation fault - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #6642: Spanish collation fault
Date
Msg-id 1337469065.10292.29.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: BUG #6642: Spanish collation fault  (Tulio J Carrasco <tulio.carrasco@gmail.com>)
List pgsql-bugs
Tree view 
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.

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #6651: macaddr length constraint violates standard
Next
From: grv87@yandex.ru
Date:
Subject: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder