From: | Alexander Pucher <pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | sort case insensitive |
Date: | 2002-11-18 21:43:31 |
Message-ID: | 3DD95F03.70408@atlas.gis.univie.ac.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Frank Bax | 2002-11-18 21:58:42 | Re: sort case insensitive |
Previous Message | Frank Yip | 2002-11-18 16:23:19 | value too long for type character varying(25) |