Re: How do you compare (NULL) and (non-NULL)?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Wei Weng <wweng(at)kencast(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: How do you compare (NULL) and (non-NULL)?
Date: 2004-10-29 17:57:54
Message-ID: 20041029175754.GB28827@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Oct 29, 2004 at 11:59:15 -0400,
Wei Weng <wweng(at)kencast(dot)com> wrote:
>
> How do I write that?

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Murphy Pope 2004-10-31 00:00:25 Re: ORDER BY and NULLs
Previous Message Markus Schaber 2004-10-29 17:46:49 Re: extra info - curious delay on view/where