Postgres Pro
Downloads
Home   >   mailing lists

Re: Making NULL entries appear first when ORDER BY ASC - Mailing list pgsql-sql

From Rosser Schwarz
Subject Re: Making NULL entries appear first when ORDER BY ASC
Date
Msg-id 37d451f705021518246bdb5b05@mail.gmail.com
Whole thread Raw
In response to Making NULL entries appear first when ORDER BY ASC  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-sql
Tree view 
while you weren't looking, Andreas Joseph Krogh wrote:

> Any idea how to achieve this?

...
ORDER BY coalesce(start_date, '1900-01-01') ASC     , coalesce(start_time, '1900-01-01') ASC;

/rls

-- 
:wq

pgsql-sql by date:

Previous
From: George Weaver
Date:
Subject: Re: Working with XML.
Next
From: Ragnar Hafstað
Date:
Subject: Re: Making NULL entries appear first when ORDER BY