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

From Peter Eisentraut
Subject Re: FW: "=" operator vs. "IS"
Date
Msg-id 200406291827.48502.peter_e@gmx.net
Whole thread Raw
In response to Re: FW: "=" operator vs. "IS"  (Rich Hall <rhall@micropat.com>)
List pgsql-sql
Rich Hall wrote:
> My question is why is the form
>
> "(anything) = NULL"
>
> allowed?
>
> Since
>
> "(anything) = NULL" is always Null, this cannot be what the coder
> intended.

Using that same line of argument, why is 1+1 allowed?  The coder clearly 
knows that it is 2, so why is he writing that?  Many queries are 
generated by automatic tools that definitely intend what they say.



pgsql-sql by date:

Previous
From: beyaNet
Date:
Subject: test1
Next
From: "Alexander M. Pravking"
Date:
Subject: Re: UPDATE ... WHERE (subselect on the same table)