Re: Case insensitive ORDER BY

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Case insensitive ORDER BY
Дата
Msg-id 20040319050249.GA16785@wolff.to
обсуждение исходный текст
Ответ на Re: Case insensitive ORDER BY  ("Alam Surya" <alam_it@csahome.com>)
Список pgsql-general
On Fri, Mar 19, 2004 at 03:48:09 +0000,
  Alam Surya <alam_it@csahome.com> wrote:
> dear expert...
>
> why does CLAUSE ORDER BY in POSTAGE SQL must have CASE SENSITIVE, what is
> the basic thought? isn't it ORDER BY function is only just a filter
> shorting?

You can use functions in an ORDER BY clause. If you want case insensitive
ordering, order by lower (or upper) of your key.

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

Предыдущее
От: "Alam Surya"
Дата:
Сообщение: Re: Case insensitive ORDER BY
Следующее
От: Matthew Hixson
Дата:
Сообщение: two phase commit