Re: sort case insensitive

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

--
________________________________________________________

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