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 по дате отправления:

Предыдущее
От: Holger Krug
Дата:
Сообщение: Re: Size of database
Следующее
От: "Arguile"
Дата:
Сообщение: Re: Select <-> Case Insensitive