sorting problem - Mailing list pgsql-general

From Jamie Deppeler
Subject sorting problem
Date
Msg-id 41C22834.7060009@doitonce.net.au
Whole thread Raw
Responses Re: sorting problem
Re: sorting problem
List 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


pgsql-general by date:

Previous
From: Chris Smith
Date:
Subject: Re: MD5
Next
From: Michael Fuhr
Date:
Subject: Re: MD5