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@sss.pgh.pa.us>
To: "Jodi Kanter" <jkanter@virginia.edu>
Cc: "Postgres SQL List" <pgsql-sql@postgresql.org>
Sent: Thursday, March 27, 2003 1:57 AM
Subject: Re: [SQL] order by
> Jodi Kanter <jkanter@virginia.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
>