Silvio Brandani <silvio.brandani@xxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
