Re: Sorting Problem - Mailing list pgsql-general

From Tom Lane
Subject Re: Sorting Problem
Date
Msg-id 17157.1060726511@sss.pgh.pa.us
Whole thread Raw
In response to Sorting Problem  ("Tim Edwards" <mor4321@hotmail.com>)
Responses Re: Sorting Problem  (Dennis Gearon <gearond@cvc.net>)
List pgsql-general
"Tim Edwards" <mor4321@hotmail.com> writes:
> When I sort ASC on the varchar I get some strange results. Here a section of
> data cut after running a sort. It starts with RM- then does RMT- Then goes
> back for more RM-.

Sounds like you're in en_US locale, or at least something other than C
locale.

Unfortunately this can only be fixed by re-initdb'ing :-(

            regards, tom lane

pgsql-general by date:

Previous
From: "Tim Edwards"
Date:
Subject: Sorting Problem
Next
From: Kathy zhu
Date:
Subject: Re: Sorting Problem