Re: NULL sorts as largest?

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: NULL sorts as largest?
Дата
Msg-id 20030527155731.U12849-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на NULL sorts as largest?  ("Dmitri Bichko" <dbichko@genpathpharma.com>)
Список pgsql-general
On Tue, 27 May 2003, Dmitri Bichko wrote:

> I am noticing that null values come out as the largest value when
> sorting on a field (or last with ASC and first with DESC).  Is there any
> way to change this behaviour?  It's somewhat strange to do a descending
> sort on a column and get all the stuff that's not there first.

I think the best you can do is ordering by field is [not] null first and
then by the field (choosing not depending on the sort order you want).




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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Bizzare plpgsql error
Следующее
От: Justin Clift
Дата:
Сообщение: Re: 7.3.2 Windows Build