Select <-> Case Insensitive
От | Marcelo Pereira |
---|---|
Тема | Select <-> Case Insensitive |
Дата | |
Msg-id | Pine.LNX.4.20.0202220922470.17523-100000@ni.hmmg.sp.gov.br обсуждение исходный текст |
Ответы |
Re: Select <-> Case Insensitive
Re: Select <-> Case Insensitive |
Список | 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_______________/
В списке pgsql-general по дате отправления: