Matthias Apitz <guru@xxxxxxxxxxx> writes: > Said that, does the SORT done by the server depends on the environment > (LANG, LC_*) in which the PostgreSQL server is started or only of the > sp_catalog information of the database in question? We set LC_COLLATE and LC_CTYPE from the database's relevant pg_database fields. The remaining LC environment variables shouldn't affect this (and I think we force them to "C" anyway). regards, tom lane