Re: Is there an answer to the Ultimate Question for PostgreSQL? - Mailing list pgsql-novice

Gregory Kotsaftis <gregkotsaftis@yahoo.com> writes:
> Do you mean we should create a db with a specific COLLATE and then depending on the user's locale we should change
thequeries? 
> for example like this:

> SELECT * FROM test1 ORDER BY a || b COLLATE "fr_FR";

Yeah.  You might also find that labeling particular table columns with
collations is useful.

            regards, tom lane