From: | Robert Voinea <robert(dot)voinea(at)topex(dot)ro> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Cc: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, "Robert (DEQ) Burgholzer" <Robert(dot)Burgholzer(at)deq(dot)virginia(dot)gov> |
Subject: | Re: Weird sorting order |
Date: | 2010-07-21 05:56:14 |
Message-ID: | 201007210856.14905.robert.voinea@topex.ro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Monday 19 July 2010 19:15:32 Kevin Grittner wrote:
> 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
Thank you for clarifying this.
--
Robert Voinea <robert (dot) voinea (at) topex (dot) ro>
Software Developer
Phone: +40 21 408 38 00 / ext. 343
Fax: +40 21 408 38 08
Local time: GMT+2
http://www.topex.ro
From | Date | Subject | |
---|---|---|---|
Next Message | Fabrízio de Royes Mello | 2010-07-21 12:16:51 | Re: Custom vacuum |
Previous Message | Alvaro Herrera | 2010-07-20 20:52:37 | Re: Autovacuum on defined interval |