Silvio Brandani <silvio(dot)brandani(at)tech(dot)sdb(dot)it> writes:
> Hi,
> lc_collate
> -------------
> en_US.UTF-8
en_US (and, in fact, most Linux locales other than C) uses "dictionary
order", which ignores pretty much everything except letters in its
first-pass comparison.
You can check that it's not just Postgres being weird by feeding the
same data through sort(1) after setting LC_COLLATE this way in its
environment. You'll get the same results.
regards, tom lane