"The problem isn't what they don't know. It's what they do know that ain't
so."
— Ronald Reagan
-
NULLs
"The problem isn't what they don't know. It's what they do know that ain't ... -
Representing Missing Data with NULL
Those missing values that we represented with question marks in our list ar... -
The Meaning of NULL
"The cat is neither alive nor dead." — Erwin Schrödinger Pay close atten... -
Three-Valued Logic
Most logical systems rest on two values: is/isn't, yes/no, 0/1, TRUE/FALSE... -
Nullability
There are times when you'll want to ensure that a null value can't be put i... -
The Duplicate Loophole
"Identification for duplicate removal is at a lower level of detail than eq... -
Fun with NULLs
There are many operations which are affected by the presence of NULLs. Our... -
Problems For Optimizers
If you were to write a DBMS optimizer, you'd want to take advantage of cert... -
Nulloclasts vs. Nullodules
If you know any Byzantine history at all, you know about the hundred-year s...