Re: sorting problem

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: sorting problem
Date: 2004-12-17 00:49:21
Message-ID: 20041217004921.GA9175@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 17, 2004 at 11:28:36AM +1100, 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.

ORDER BY LOWER(person.lastname)

or

ORDER BY UPPER(person.lastname)

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-12-17 00:59:32 Re: sorting problem
Previous Message Peter Eisentraut 2004-12-17 00:45:36 Re: sorting problem