| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Robert (DEQ) Burgholzer" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov>, <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Weird sorting order |
| Date: | 2010-07-19 16:15:32 |
| Message-ID: | 4C4433D402000025000338D1@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Burgholzer, Robert (DEQ)" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ENGEMANN, DAYSE | 2010-07-19 16:31:18 | Re: How to move a database from HP server to Linux Server that had already one database. |
| Previous Message | Kevin Grittner | 2010-07-19 16:07:10 | Re: How to move a database from HP server to Linux Server that had already one database. |