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

Поиск
Список
Период
Сортировка
От Rich Hall
Тема Re: FW: "=" operator vs. "IS"
Дата
Msg-id 40E17C81.3090308@micropat.com
обсуждение исходный текст
Ответ на FW: "=" operator vs. "IS"  ("Dmitri Bichko" <dbichko@genpathpharma.com>)
Ответы Re: FW: "=" operator vs. "IS"
Re: FW: "=" operator vs. "IS"
Re: FW: "=" operator vs. "IS"
Re: FW: "=" operator vs. "IS"
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: "Phil Endecott"
Дата:
Сообщение: Re: finding if a foreign key is in use
Следующее
От: Tom Lane
Дата:
Сообщение: Re: FW: "=" operator vs. "IS"