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