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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Rich Hall <rhall(at)micropat(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: FW: "=" operator vs. "IS"
Date: 2004-06-29 16:27:48
Message-ID: 200406291827.48502.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message beyaNet 2004-06-29 16:31:43 test1
Previous Message Tom Lane 2004-06-29 16:18:17 Re: Unrecognized node type