Re: Select <-> Case Insensitive

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