Silvio Brandani <silvio.brandani@tech.sdb.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
