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

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: sort case insensitive
Date: 2002-11-18 21:43:31
Message-ID: 3DD95F03.70408@atlas.gis.univie.ac.at (view raw or flat)
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



Responses

pgsql-novice by date

Next:From: Frank BaxDate: 2002-11-18 21:58:42
Subject: Re: sort case insensitive
Previous:From: Frank YipDate: 2002-11-18 16:23:19
Subject: value too long for type character varying(25)

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