Re: sort case insensitive - Mailing list pgsql-novice

From Alexander Pucher
Subject Re: sort case insensitive
Date
Msg-id 3DD96398.6080901@atlas.gis.univie.ac.at
Whole thread Raw
In response to Re: sort case insensitive  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
Thankx, works!!

Best regards,
alex

Frank Bax wrote:

> 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
>>


--
________________________________________________________

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



pgsql-novice by date:

Previous
From: Frank Bax
Date:
Subject: Re: sort case insensitive
Next
From: Hugh Esco
Date:
Subject: Re: [SQL] Problems invoking psql. Help please.