Re: incorrect collation order in at least some non-C locales - Mailing list pgsql-bugs

From Tom Lane
Subject Re: incorrect collation order in at least some non-C locales
Date
Msg-id 12508.1139168996@sss.pgh.pa.us
Whole thread Raw
In response to Re: incorrect collation order in at least some non-C locales  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> This is probably not "broken collation order" but instead how those
> locales are defined.

I'd only consider it "broken" if you get different sort order from
sort(1) under the same locale.  Here is an example from Fedora 4
showing that sort(1) has the same ideas about what de_DE sort order
is:

[tgl ~]$ cat zzz
SUEKO
SUE E
SUE T
[tgl ~]$ sort zzz
SUE E
SUE T
SUEKO
[tgl ~]$ LANG=de_DE.utf8 sort zzz
SUE E
SUEKO
SUE T
[tgl ~]$

            regards, tom lane

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: incorrect collation order in at least some non-C locales
Next
From: "Olleg Samoylov"
Date:
Subject: BUG #2239: "vacuumdb -a" remove freeze