Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov>
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@vanquo.pezone.net
-Kevin