Re: unexpected (to me) sorting order

From: Björn Lundin <b(dot)f(dot)lundin(at)gmail(dot)com>
To: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: unexpected (to me) sorting order
Date: 2015-04-08 09:45:35
Message-ID: 5524F8BF.60608@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2015-04-08 11:33, Glyn Astill wrote:

> The collation of your "bnl" database is utf8, so the "." punctuation
> character is seen as a "variable element" and given a lower weighting in
> the sort to the rest of the characters. That's just how the collate
algorithm works in UTF8.
> Try with LC_COLLATE = 'C' and it should sort how you expect.
>

Ok.
And as Chris Mair says in his answer, it looks like the '.' is
ignored, and then I see the pattern
Thanks

--
Björn

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Björn Lundin 2015-04-08 09:47:00 Re: unexpected (to me) sorting order
Previous Message Chris Mair 2015-04-08 09:36:01 Re: unexpected (to me) sorting order