Quote:
Originally Posted by joder
In the database world, NULL does not mean 0. NULL means the lack of any value.
You can cat >> /dev/null and it disappears 
|
That's one way of thinking about Null, another is that it is just uninitialized. When you create a variable in langauge like java and c++, and I'm assuming what most databases are based on, you set aside the memory for whatever it is that is that your variable is going to reference. In more cases that memory has something in it left over from whatever program was using that memory before.
My point being, in some less type safe languages you can take an uninitialized variable (a variable that is set to null) and access some value of that variable. Obviously doing so is completely useless so long as your intent is good.
My professors have told me stories about people indexing outside of the bounds of their arrays and doing strange things: Like a program that restarts the computer everytime it runs, or a program that starts printing out its own source code.
Anyways to summerize... it may be the case that the conceptual definition of null is the complete lack of value, but in practice that is not the case.
|