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

From Tom Lane
Subject Re: FW: "=" operator vs. "IS"
Date
Msg-id 29590.1088521065@sss.pgh.pa.us
Whole thread Raw
In response to Re: FW: "=" operator vs. "IS"  (Rich Hall <rhall@micropat.com>)
List pgsql-sql
Rich Hall <rhall@micropat.com> writes:
> My question is why is the form
> "(anything) = NULL"
> allowed?

If you think it shouldn't be, you can turn on the transform_null_equals
flag.  However, past experience has shown that that breaks more things
than it fixes.  In any case, few people like to depend on such a
thoroughly nonstandard behavior ...
        regards, tom lane


pgsql-sql by date:

Previous
From: Rich Hall
Date:
Subject: Re: FW: "=" operator vs. "IS"
Next
From: Michael Kleiser
Date:
Subject: Re: FW: "=" operator vs. "IS"