Postgres Pro
Downloads
Home   >   mailing lists

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 21817.1077633763@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #1082: Order by doesn't sort correctly.  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-bugs
Tree view 
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> I verified this, and it's not GB specific as one might suggest... Same
> with en_US, de_DE, fr_FR, af_ZA.

Yeah, most of the locales use dictionary ordering rules.

> Does this behaviour really make sense to anybody?

You'd have to argue about it with the people who work on locales.
AFAIK it is a standard of some kind.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: BUG #1082: Order by doesn't sort correctly.
Next
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1084: dropping in-use index causes "could not open relation with OID..."