Re: order by

When we originally initialized I set the LC_COLLATE=C. Was this not enough?
We set it in the environment variables for the postgres user.
Thanks
Jodi

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jodi Kanter" <jkanter(at)virginia(dot)edu>
Cc: "Postgres SQL List" <pgsql-sql(at)postgresql(dot)org>
Sent: Thursday, March 27, 2003 1:57 AM
Subject: Re: [SQL] order by

> Jodi Kanter <jkanter(at)virginia(dot)edu> writes:
> > Is there a known problem with the SQL order by clause within postgres
versi=
> > on 7.2.3?
>
> No ... but it does honor the sorting rules of the locale you initialize
> the database in. You might want to re-initdb with LC_ALL set to C.
>
> regards, tom lane
>