Re: [GENERAL] Sorting Problem

[Jeffrey Melloy]

It does if you look at the original email.  Maksim must've just 
transposed a couple letters when he was writing his demo.

Jeff

Kathy zhu wrote:

If it skips "-", then RMT-* should come before RM-V*, but they don't, 
why  ??

Maksim Likharev wrote:

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 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])