Postgres Pro
Downloads
Home   >   mailing lists

Re: problem with ORDER BY - Mailing list pgsql-general

From Nicolas KOWALSKI
Subject Re: problem with ORDER BY
Date
Msg-id 87k5lo65pm.fsf@petole.dyndns.org
Whole thread Raw
In response to Re: problem with ORDER BY  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: problem with ORDER BY
List pgsql-general
Tree view 
Tom Lane <tgl@sss.pgh.pa.us> 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore fails for postgis data dump
Next
From: "Santiago Zarate"
Date:
Subject: Re: [pgsql-advocacy] PostgreSQL Certification