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
>
>
