ORDER BY and null values - Mailing list pgsql-general

From Paulo Jan
Subject ORDER BY and null values
Date
Msg-id 3D2C22D0.A941396D@digital.ddnet.es
Whole thread Raw
Responses Re: ORDER BY and null values
List 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 by date:

Previous
From: Christoph Dalitz
Date:
Subject: static linkage with libpq?
Next
From: Andreas Schlegel
Date:
Subject: Flag for insentive use of Postgres?