Re: sort case insensitive

try: ORDER BY lower(fieldname)

At 04:43 PM 11/18/02, Alexander Pucher wrote:

>hi,
>
>can someone give me a quick hint on how to sort case insenstive.
>
>my 'select' clause with an 'order by' gives me this result:
>
>Green
>Miller
>adams
>
>by of course, I would like to get
>
>adams
>Green
>Miller
>
>Best Regards,
>alex
>
>--
>________________________________________________________
>
>Institut fuer Geographie und Regionalforschung
>Universitaet Wien
>Kartografie und Geoinformation
>
>Departement of Geography and Regional Research
>University of Vienna
>Cartography and GIS
>
>Universitaetstr. 7, A-1010 Wien, AUSTRIA
>
>Tel: (+43 1) 4277 48644
>Fax: (+43 1) 4277 48649
>E-mail: alexander(dot)pucher(at)univie(dot)ac(dot)at
>
>FTP: ftp://ftp.gis.univie.ac.at
>WWW: http://www.gis.univie.ac.at/karto
>--------------------------------------------------------
>Virtual Map Forum: http://www.gis.univie.ac.at/vmf
>--------------------------------------------------------
>
>M$ is not the answer. M$ is the question!
>No is the answer -- Eric Naggum
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>