Re: Sorting Problem

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:Kathy.zhu@Sun.COM]
>> Sent: Tuesday, August 12, 2003 3:30 PM
>> To: Tom Lane
>> Cc: Tim Edwards; pgsql-general@postgresql.org
>> 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" <mor4321@hotmail.com> 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
>>
>>
>> majordomo@postgresql.org)
>>
>>