Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15651: Collation setting en_US.utf8 breaking sort order - Mailing list pgsql-bugs

From Peter Geoghegan
Subject Re: BUG #15651: Collation setting en_US.utf8 breaking sort order
Date
Msg-id CAH2-WzksFxYVuixFWo-jfgh9p75LjfA3dVxLxiq4NhDFOynEiA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15651: Collation setting en_US.utf8 breaking sort order  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: BUG #15651: Collation setting en_US.utf8 breaking sort order  (Kaleb Akalework <kaleb.akalework@asg.com>)
List pgsql-bugs
Tree view 
On Fri, Feb 22, 2019 at 10:03 AM Tom Lane <tgl@sss.pgh.pa.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

pgsql-bugs by date:

Previous
From: Kaleb Akalework
Date:
Subject: RE: BUG #15651: Collation setting en_US.utf8 breaking sort order
Next
From: Kaleb Akalework
Date:
Subject: RE: BUG #15651: Collation setting en_US.utf8 breaking sort order