Re: Select <-> Case Insensitive

What about 'ilike' ???

http://www.postgresql.org/idocs/index.php?functions-matching.html

mfg
ALEX

--
________________________________________________________

Institut fuer Geographie und Regionalforschung
Universität 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: pucher(at)atlas(dot)gis(dot)univie(dot)ac(dot)at

FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
________________________________________________________

"There is a difference between happiness and wisdom: he that thinks himself the happiest man is really so; but he that thinks himself the wisest is generally the greatest fool"-- Francis Bacon

Marcelo Pereira wrote:

>Hello All,
>
>How can I do a query make the `order' statment sort the tuples without
>looking for the `case' ?
>
>I have a table like this:
>
>cod | Description
>----+----------------
> 1 | A
> 2 | B
> 3 | C
> 4 | a
> 5 | b
> 6 | c
>
>I would like to do a `select * from thistable order by description' that
>returns the following:
>
>cod | Description
>----+----------------
> 1 | A
> 4 | a
> 2 | B
> 5 | b
> 3 | C
> 6 | c
>
>How can I do it?
>
>[Ps.: Sorry by this simply question, but I couldn't find anything at the
>man pages!!]
>
>Thanks in advance.
>
>Marcelo Pereira
>
>-- Remember that only God and Esc+:w saves.
> __
> (_.\ Marcelo Pereira |
> / / ___ |
> / (_/ _ \__ Matematica/99 - IMECC |
>_______\____/_\___)___Unicamp_______________/
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>