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

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
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:33:23
Message-ID: 873c4ez2u4.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

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

--
greg

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Greg Stark 2004-06-29 17:37:21 Re: FW: "=" operator vs. "IS"
Previous Message Alexander M. Pravking 2004-06-29 17:28:49 Re: UPDATE ... WHERE (subselect on the same table)