Search Postgresql Archives

Re: problem with ORDER BY

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom Lane <tgl@xxxxxxxxxxxxx> writes:

> The ordering you showed is correct according to en_US (and most other
> non-C locales).  The ordering you want is used in "C" locale.
> Unfortunately you have to re-initdb to change the locale of a
> database :-(
> 	initdb --locale=C

Thanks Tom, using the C locale as indicated gets this right in our
database.

Best regards,
-- 
Nicolas

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux