Select <-> Case Insensitive

From: Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Select <-> Case Insensitive
Date: 2002-02-22 12:32:21
Message-ID: Pine.LNX.4.20.0202220922470.17523-100000@ni.hmmg.sp.gov.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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_______________/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arguile 2002-02-22 12:43:39 Re: Select <-> Case Insensitive
Previous Message Roman 2002-02-22 11:49:23 funciton returning result of a select statement