Re: [GENERAL] Sorting Problem

[Dennis Gearon]

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" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED])


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])