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