Re: So what's null then if it's not nothing?
Date: Thu, 24 Nov 2005 11:59:54 +0100
Message-ID: <43859d3d$1_at_news.fhg.de>
Jon Heggland schrieb:
> In article <1132798608.160942.270970_at_o13g2000cwo.googlegroups.com>,
> michael_at_preece.net says...
>
>>If you have a text/string field and it can have an empty string what >>have you got? What is the value of the data? How does that value differ >>from "no value at all"? Question mark.
>
>
> Are two variables/"fields" (of the same type) with "no value at all"
> equal?
The question does not make sense because we cannot talking about things that do not exist. In particular, it does not make sense to ask if two things that do not exist are equal or not. Why not to ask then if two records that have not been created yet (or have been already deleted) are equal?
The issue of comparison of nulls with normal values or with other nulls arose because inappropriate application of attribute-value approach. In particular, the standard reasoning is that if we see some attribute then it is necessary to have a facility to take its value and to compare with other values. It is a consequence of a general assumption that:
all objects have some coordinates along appropriate dimensions
However, there is another (more general) principle:
objects may exist in multidimensional space without the necessity to exist in (to be projected to) all axes.
The traditional approach is somewhat dogmatic: if such a coordinate is not assigned then we must assign some special value and then compare it with other values anyway. This does not make sense. If an object does not exist along this coordiante then it does not exist, and that is all. We do not see it. And any database procedure does not see it. Because having a coordinate means to exist.
-- http://conceptoriented.comReceived on Thu Nov 24 2005 - 11:59:54 CET