Re: Null ordering in queries can be changed by settings?

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Null ordering in queries can be changed by settings?
Дата
Msg-id kfl4ja$rfd$1@ger.gmane.org
обсуждение исходный текст
Ответ на Null ordering in queries can be changed by settings?  (Vincenzo Melandri <vmelandri@imolinfo.it>)
Список pgsql-novice
Дерево обсуждения 
Vincenzo Melandri, 15.02.2013 11:14:
> I stepped into the same problem as this guy from 2005.
> Is this problem changed in the last 8 years? :)
> Can it be changed from settings now?

You can use the SQL standard NULLS LAST/NULLS FIRST operator

select *
from foo
order by bar desc nulls last

select *
from foo
order by bar desc nulls first

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

Предыдущее
От: Vincenzo Melandri
Дата:
Сообщение: Null ordering in queries can be changed by settings?
Следующее
От: Zach Seaman
Дата:
Сообщение: Re: Insert output query to a column from a joined table in PostgreSQL 9.1