Re: BUG #15651: Collation setting en_US.utf8 breaking sort order

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: kaleb(dot)akalework(at)asg(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #15651: Collation setting en_US.utf8 breaking sort order
Date: 2019-02-22 18:40:58
Message-ID: CAH2-WzksFxYVuixFWo-jfgh9p75LjfA3dVxLxiq4NhDFOynEiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Feb 22, 2019 at 10:03 AM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> This appears to be the intended behavior of en_US sorting.

Right. UCA style algorithms tend to give the least weight of all to
whitespace characters. They're tertiary weight, if memory serves.

--
Peter Geoghegan

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Kaleb Akalework 2019-02-22 19:17:06 RE: BUG #15651: Collation setting en_US.utf8 breaking sort order
Previous Message Kaleb Akalework 2019-02-22 18:18:16 RE: BUG #15651: Collation setting en_US.utf8 breaking sort order