News for hackers. Stuff that matters.
Re:Probabilistic Data Structure Showdown: Cuckoo Filters vs.... by jakewins on Monday November 28, 2016 @06:50PM (#13059445)
As an aside, this is how null is defined in many languages as well. Many behaviors of SQL, for instance, are much more intuitive if you remember that SQL sees null as "unknown".

If a boolean value is null in SQL, it conceptually means it could be either true or false - it's a maybe. If you ask "is maybe true equal to maybe true", the answer is "maybe". Likewise, asking SQL 'null = null", it answers "null", instead of true/false.

Re:Probabilistic Data Structure Showdown: Cuckoo Filters vs.... by 443633456 on Tuesday November 29, 2016 @12:03AM (#13060963)
...which is why for determining if something is unknown, you ask SQL...are you indeed NULL? And SQL should say 'true' or 'false'.

    SQL null IS null