Re:The Meaning of Null in Databases and Programming Language...
by nerdponx on Monday May 04, 2020 @07:55PM
(#23074786)
I think I understand what they're trying to say.
The value of a variable with type "non-nullable 32-bit integer" is an element of the space {-231, ..., 231 - 1}. The value of a variable with type "nullable 32-bit integer" is an element of the space {-231, ..., 2*31 - 1} U {NULL}.
There's a "main space", and an extra singleton space tacked on, containing the "NULL" element.
So NULL isn't a value in the "main space", and therefore in some sense "isn't a value". I think it's wrong for the same reasons you stated, but I think this is what they were trying to describe.
The value of a variable with type "non-nullable 32-bit integer" is an element of the space {-231, ..., 231 - 1}. The value of a variable with type "nullable 32-bit integer" is an element of the space {-231, ..., 2*31 - 1} U {NULL}.
There's a "main space", and an extra singleton space tacked on, containing the "NULL" element.
So NULL isn't a value in the "main space", and therefore in some sense "isn't a value". I think it's wrong for the same reasons you stated, but I think this is what they were trying to describe.