Re: BUG #1082: Order by doesn't sort correctly. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1082: Order by doesn't sort correctly.
Date
Msg-id 13563.1077403667@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1082: Order by doesn't sort correctly.  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
Responses Re: BUG #1082: Order by doesn't sort correctly.  (Richard Neill <rn214@hermes.cam.ac.uk>)
List pgsql-bugs
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Description:        Order by doesn't sort correctly.

It almost certainly is the correct sort order according to the locale
you're using.  Use pg_controldata to check the database locale.  You'll
probably want to re-initdb in C locale.  Most non-C locales have weird
rules that try to approximate dictionary sort order.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1082: Order by doesn't sort correctly.
Next
From: Tom Lane
Date:
Subject: Re: BUG #1082: Order by doesn't sort correctly.