Re: "= Null" <> "is Null"?

Durumdara <durumdara@gmail.com> writes:

> Some of other DBs are uses Null as Null in >=< comparisons. Is PG not?
> What are the rules?

PostgreSQL implements SQL, which has a 3-valued logic. There's True,
there's False, and there's NULL. NULL means that we know nothing about
what's in there.

Would you really want to say that something you know nothing about is
the same thing as this other thing you know nothing about?

In PostgreSQL, NULL = NULL answers NULL (we know nothing about the
result).

Regards,
--
dim