ORDER BY and null values

Поиск
Список
Период
Сортировка
От Paulo Jan
Тема ORDER BY and null values
Дата
Msg-id 3D2C22D0.A941396D@digital.ddnet.es
обсуждение исходный текст
Ответы Re: ORDER BY and null values  (Bruno Wolff III <bruno@wolff.to>)
Список pgsql-general
Hi all:

    Sorry if this has been asked before. Just did a quick search in the
archives and didn't find anything that was 100% relevant.
    I have a table with a date field, where some of the rows are empty
(with NULL values) and some aren't. I need to make a "SELECT <blah blah>
ORDER BY date DESC" but my customer wants the rows with empty values to
appear at the bottom of the result set, instead of at the top. Is this
possible?



                        Paulo Jan.
                        DDnet.

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

Предыдущее
От: Christoph Dalitz
Дата:
Сообщение: static linkage with libpq?
Следующее
От: Andreas Schlegel
Дата:
Сообщение: Flag for insentive use of Postgres?