Re: FW: "=" operator vs. "IS" - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: FW: "=" operator vs. "IS"
Date
Msg-id 20040629104400.M63066@megazone.bigpanda.com
Whole thread Raw
In response to FW: "=" operator vs. "IS"  ("Dmitri Bichko" <dbichko@genpathpharma.com>)
List pgsql-sql
On Tue, 29 Jun 2004, Greg Stark wrote:

> Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
>
> > IS TRUE and IS FALSE have a different effect from =true and =false when
> > the left hand side is NULL. The former will return false, the latter will
> > return NULL.
>
> No, actually they both return false.

For purposes of anyone reading this in the archives I'd meant NULL IS TRUE
and NULL IS FALSE return false vs NULL=true and NULL=false returning
NULL.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: UPDATE ... WHERE (subselect on the same table)
Next
From: Greg Stark
Date:
Subject: Re: FW: "=" operator vs. "IS"