Re: FW: "=" operator vs. "IS"

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Stefan Weiss <spaceman(at)foo(dot)at>, pgsql-sql(at)postgresql(dot)org
Subject: Re: FW: "=" operator vs. "IS"
Date: 2004-06-29 17:46:03
Message-ID: 20040629104400.M63066@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 29 Jun 2004, Greg Stark wrote:

> Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2004-06-29 21:25:18 Re: OUTER JOIN problem
Previous Message Greg Stark 2004-06-29 17:37:21 Re: FW: "=" operator vs. "IS"