sorting problem

From: Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: sorting problem
Date: 2004-12-17 00:28:36
Message-ID: 41C22834.7060009@doitonce.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

SQL Query

SELECT
*
FROM
person
WHERE
(salutation LIKE '%To%')
ORDER BY
person.lastname

Results

Ahsteit
Bloggs
Cap
Carrey
Diver
Duckula
Goldsworthy
Gruff
Harmony
Hassleberry-flop-flop
Heyheagle
Jahoosal
Straindove
Yorrick
of Finchery

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-12-17 00:35:24 Re: MD5
Previous Message Chris Smith 2004-12-17 00:25:29 Re: MD5