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

From Greg Stark
Subject Re: FW: "=" operator vs. "IS"
Date
Msg-id 873c4ez2u4.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: FW: "=" operator vs. "IS"  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-sql
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.

(But thanks, I didn't even realize they were special this way)

-- 
greg



pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: FW: "=" operator vs. "IS"
Next
From: Zoltan Boszormenyi
Date:
Subject: OUTER JOIN problem