Hi,
The query
SELECT * from mytable order by lower(description);
could solve your problem.
test=# SELECT * from mycase order by lower(descr);
code | descr
------+-------
1 | A
4 | a
2 | B
5 | b
3 | C
6 | c
Regards,
Devrim
On Fri, 22 Feb 2002, 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
>
--
Devrim GUNDUZ
devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net
Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------