Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Hall
Subject Re: FW: "=" operator vs. "IS"
Date
Msg-id 40E17C81.3090308@micropat.com
Whole thread Raw
In response to FW: "=" operator vs. "IS"  ("Dmitri Bichko" <dbichko@genpathpharma.com>)
Responses Re: FW: "=" operator vs. "IS"
Re: FW: "=" operator vs. "IS"
Re: FW: "=" operator vs. "IS"
Re: FW: "=" operator vs. "IS"
List pgsql-sql
Tree view 
My question is why is the form

"(anything) = NULL"

allowed?

Since

"(anything) = NULL" is always Null, this cannot be what the coder intended. 

This is much different when comparing two variables, where the coder may have to handle the cases where the variables
areNull. Here the comparison is to a constant.
 




Rick

pgsql-sql by date:

Previous
From: "Phil Endecott"
Date:
Subject: Re: finding if a foreign key is in use
Next
From: Tom Lane
Date:
Subject: Re: FW: "=" operator vs. "IS"