| 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: | Whole Thread | Raw Message | 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 |