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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
