"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])