Postgres Pro
Downloads
Home   >   mailing lists

Re: How do you compare (NULL) and (non-NULL)? - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: How do you compare (NULL) and (non-NULL)?
Date
Msg-id 20041029175754.GB28827@wolff.to
Whole thread Raw
In response to Re: How do you compare (NULL) and (non-NULL)?  (Wei Weng <wweng@kencast.com>)
List pgsql-sql
Tree view 
On Fri, Oct 29, 2004 at 11:59:15 -0400, Wei Weng <wweng@kencast.com> wrote:
> 
> How do I write that?

SELECT Parent FROM Channels ORDER BY Parent IS NULL, Parent ASC;

pgsql-sql by date:

Previous
From: Wei Weng
Date:
Subject: Re: How do you compare (NULL) and (non-NULL)?
Next
From: Markus Schaber
Date:
Subject: Re: extra info - curious delay on view/where