Select <-> Case Insensitive - Mailing list pgsql-general

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