Re: ORDER BY options (how to order data as AAA, aaa,

Поиск
Список
Период
Сортировка
От Ragnar Hafstað
Тема Re: ORDER BY options (how to order data as AAA, aaa,
Дата
Msg-id 1115720640.24340.13.camel@localhost.localdomain
обсуждение исходный текст
Ответ на ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)  (Julian Legeny <julo@opensubsystems.org>)
Список pgsql-general
Дерево обсуждения 
On Tue, 2005-05-10 at 11:41 +0200, Julian Legeny wrote:

> ...
> But I would like to sort all data as following:
>
>    NAME
> -----------
>    AAA
>    aaa
>    BBB
>    bbb
>    CCC
>    ccc

> How can I write sql command (or set up ORDER BY options) for selecting that?

how about ORDER BY lower(NAME),NAME ?

gnari

В списке pgsql-general по дате отправления:

Предыдущее
От: "Sim Zacks"
Дата:
Сообщение: Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)
Следующее
От: Julian Legeny
Дата:
Сообщение: Re: ORDER BY options (how to order data as AAA, aaa, BBB, bbb, ... ZZZ, zzz)