Re: order by query wrong result

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