Re: Sorting Problem

To help my understanding of this type of thing, when he reinits the database, can he get the PG backend to be running with a different LOCALE than the machine's?

Tom Lane wrote:

> "Tim Edwards" <mor4321(at)hotmail(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>