Burgholzer, Robert (DEQ)" <Robert.Burgholzer@xxxxxxxxxxxxxxxx> wrote: > This is really interesting. Is there a way to set the locale on > the fly for a sort? Having looked at the docs, it appears as if > the initDB step is the only opportunity to do so. Starting with 8.4 you can specify it at the database level: http://www.postgresql.org/docs/8.4/interactive/sql-createdatabase.html Peter Eisentraut is working on a way to set the collation for an individual column or (I think) for a sort; but that won't be in 9.0. Hopefully in 9.1.... http://archives.postgresql.org/message-id/1279045531.32647.14.camel@xxxxxxxxxxxxxxxxx -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin