Skip site navigation (1) Skip section navigation (2)

Re: sort case insensitive

From: Alexander Pucher <pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: sort case insensitive
Date: 2002-11-18 22:03:04
Message-ID: 3DD96398.6080901@atlas.gis.univie.ac.at (view raw or flat)
Thread:
Lists: 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(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



In response to

pgsql-novice by date

Next:From: Trenks ParkDate: 2002-11-18 23:24:33
Subject: Why am I getting this message sometimes?
Previous:From: Frank BaxDate: 2002-11-18 21:58:42
Subject: Re: sort case insensitive

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group