en_US locale skips? punctuation from sorting index, so in your case RM-791 RM-AV2100 RM-PP401 RM-PP402 RM-PP404 RM-V10 RM-V11 RM-V12 RMT-D10 RMT-D108A RMT-D109A RMT-D116A RMT-V402
==> RM791 RMAV2100 RMPP401 RMPP402 RMPP404 RMV10 RMV11 RMV12 RMTD10 RMTD108A RMTD109A RMTD116A RMTV402 -----Original Message----- From: Kathy zhu [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 3:30 PM To: Tom Lane Cc: Tim Edwards; [EMAIL PROTECTED] Subject: Re: [GENERAL] Sorting Problem 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
