Re: NULL sorts as largest? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: NULL sorts as largest?
Date
Msg-id 20030527155731.U12849-100000@megazone23.bigpanda.com
Whole thread Raw
In response to NULL sorts as largest?  ("Dmitri Bichko" <dbichko@genpathpharma.com>)
List 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 by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Bizzare plpgsql error
Next
From: Justin Clift
Date:
Subject: Re: 7.3.2 Windows Build