Re:Easy Steps to a Complete Understanding of SQL
by dragonwriter on Tuesday September 03, 2013 @04:56PM
(#6323685)
> NULL is a marker that means this data value does not exist in the database.
Both of the uses I stated are data values that do not exist in the database.
> Your second, and any other 'meanings' are a misuse of NULL
No, they aren't. They are different, and substantively different, reasons why data does not exist in a database. One is the value does not exist in the domain of which the DB is model, and one is that the value exists in that domain but it is not known.
(Others have pointed out the additional case of "we do not know if it exists", which is ambiguity between those two cases.)
These two substantially different meanings of NULL were recognized fairly early in the history of the relational model by the creator of the model (E.F. Codd), who proposed refining the model by having separate markers for each of those two cases.
Both of the uses I stated are data values that do not exist in the database.
> Your second, and any other 'meanings' are a misuse of NULL
No, they aren't. They are different, and substantively different, reasons why data does not exist in a database. One is the value does not exist in the domain of which the DB is model, and one is that the value exists in that domain but it is not known.
(Others have pointed out the additional case of "we do not know if it exists", which is ambiguity between those two cases.)
These two substantially different meanings of NULL were recognized fairly early in the history of the relational model by the creator of the model (E.F. Codd), who proposed refining the model by having separate markers for each of those two cases.