Re: "= Null" <> "is Null"?

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alban Hertroys <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl>
Cc: Durumdara <durumdara(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: "= Null" <> "is Null"?
Date: 2009-07-08 13:58:43
Message-ID: dcc563d10907080658vda04970l2c0a3ae1ec5ea791@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Jul 8, 2009 at 6:03 AM, Alban
Hertroys<dalroi(at)solfertje(dot)student(dot)utwente(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien FLAESCH 2009-07-08 14:40:38 INTERVAL documentation bug?
Previous Message Andreas Wenk 2009-07-08 13:19:56 Re: [Re: Password?]