Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Durumdara <durumdara@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux