Re: order by question

On 08/07/2014 12:10 PM, Adrian Klaver wrote:
> On 08/07/2014 08:53 AM, Steve Clark wrote:
>> On 08/07/2014 11:36 AM, Kevin Grittner wrote:
>>> Steve Clark <sclark(at)netwolves(dot)com> wrote:
>>>
>>> --
>>> Kevin Grittner
>>> EDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>> Hi Kevin,
>>
>> Thanks for the response. I get the same thing as postgres if I sort from
>> the command line too. But I don't understand why.
> Because that is how en_US.UTF-8 sorts. You are probably looking for the
> 'C' sort order. For more explanations see:
>
> http://rhaas.blogspot.com/2012/03/perils-of-collation-aware-comparisons.html
>
> http://superuser.com/questions/227925/in-utf-8-collation-why-11-is-less-then-1
>
>> I would expect '-F' to sort immediately after '-' and '--' not after 'F' as
>> well as ' Feneric' (spaceFeneric) and ' Generic' (spaceGeneric) to sort
>> immediately after ' ' (space).
>>
>> It is like the space character and the - in -Letter is ignored.
> See the second link above for why that is.
>
>>
>
Thanks Adrian and Kevin,

for the explanations and links. They were very elucidating. At least now I understand what is happening.

Thanks again.

--
Stephen Clark