Re: "= Null" <> "is Null"? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: "= Null" <> "is Null"?
Date
Msg-id dcc563d10907080658vda04970l2c0a3ae1ec5ea791@mail.gmail.com
Whole thread Raw
In response to Re: "= Null" <> "is Null"?  (Alban Hertroys <dalroi@solfertje.student.utwente.nl>)
List pgsql-general
On Wed, Jul 8, 2009 at 6:03 AM, Alban
Hertroys<dalroi@solfertje.student.utwente.nl> wrote:
> This is exactly the reason the 'is null' operator exists. It's exclusively
> for checking for null values. You can't say 'is_deleted is true' for
> example.

Uh, yes you can.  is false also works. and is not true and is not false.

pgsql-general by date:

Previous
From: Andreas Wenk
Date:
Subject: Re: [Re: Password?]
Next
From: Sebastien FLAESCH
Date:
Subject: INTERVAL documentation bug?