Re: Sorting Problem

and they come:

sorted asc:
RM-791
RM-AV2100
RM-PP401
RM-PP402
RM-PP404
RMT-D10
RMT-D108A
RMT-D109A
RMT-D116A
RMT-V402
RM-V10
RM-V11
RM-V12

sorted asc:
RM791
RMAV2100
RMPP401
RMPP402
RMPP404
RMTD10
RMTD108A
RMTD109A
RMTD116A
RMTV402
RMV10
RMV11
RMV12

I think I copied and pasted wrogn, sorry.

-----Original Message-----
From: Kathy zhu [mailto:Kathy(dot)zhu(at)Sun(dot)COM]
Sent: Tuesday, August 12, 2003 4:08 PM
To: Maksim Likharev
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Sorting Problem

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(dot)zhu(at)Sun(dot)COM]
> Sent: Tuesday, August 12, 2003 3:30 PM
> To: Tom Lane
> Cc: Tim Edwards; pgsql-general(at)postgresql(dot)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(at)hotmail(dot)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(at)postgresql(dot)org)
>
>

--