Re: sorting problem

On Fri, Dec 17, 2004 at 01:45:36AM +0100, Peter Eisentraut wrote:
> Jamie Deppeler wrote:
> > Problem i am having at the moment i cant get a true alpha sort to
> > work as Order By is sorting A..Z then a..z where i need aA..zZ sort
> > independant of case.
>
> Initialize the database cluster with a locale setting other than "C".

Hmmm...did I misunderstand something when I recommended using
ORDER BY LOWER(person.lastname)?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/