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/ ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
