ORDER BY and null values

From: Paulo Jan <admin(at)digital(dot)ddnet(dot)es>
To: pgsql-general(at)postgresql(dot)org
Subject: ORDER BY and null values
Date: 2002-07-10 12:04:32
Message-ID: 3D2C22D0.A941396D@digital.ddnet.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-07-10 12:20:48 Re: Serious Crash last Friday
Previous Message Andreas Schlegel 2002-07-10 12:03:30 Flag for insentive use of Postgres?