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@atlas.gis.univie.ac.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
thinkshimself 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@postgresql.org so that your
>message can get through to the mailing list cleanly
>
>