Do you mean that soring doesn't work for en_US locale ??? And, does encoding affect sorting at all ??
thanks, kathy
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 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
