Re: sort case insensitive - Mailing list pgsql-novice

From Frank Bax
Subject Re: sort case insensitive
Date
Msg-id 5.1.1.6.0.20021118165803.0294d2b0@pop6.sympatico.ca
Whole thread Raw
In response to sort case insensitive  (Alexander Pucher <pucher@atlas.gis.univie.ac.at>)
List pgsql-novice
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.pucher@univie.ac.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@postgresql.org
>

pgsql-novice by date:

Previous
From: Alexander Pucher
Date:
Subject: sort case insensitive
Next
From: Alexander Pucher
Date:
Subject: Re: sort case insensitive