First, let's ensure that our terminology is correct:
1) "Number" and "numeral" are, by no means, synonymous: a "numeral" is a
symbol that
represents a "number".
A way to understand the difference between numbers and numerals is to consider
dice. There are dots on each of the six sides of a die. There are different
numbers of dots on each of the six sides. On typical dice,
there are no numerals, only a
number (i.e., "quantity") of dots.
The inventor(s) of dice could have put any number of dots on each face of each die: so, instead of the dot quantities: ".", "..", "...", "....", ".....", and "......", the dot quantities could just as easily have been: " " (<- blank), ".", "..", "...", "....", and ".....". In the latter example, the
number of dots on the highest-quantity face enumerate to "five", which we represent with the
numeral "
5"; Romans would have represented the same
number with the
numeral "
V". The numbers are identical...the numerals are nothing alike.
The
number of dots on the lowest-quantity die face enumerate to "zero", which we represent with the
numeral "
0";
2) "Null" and "Zero" are not equal. "Zero" is a specific numeric value; "NULL" is an unknown value. A zero value is not equal to an UNKNOWN value. Here is programmatical evidence:
Code:
SQL> select case when 0 = null then '0 = null'
2 when 0 is null then '0 is null'
3 when 0 = 0 then '0 not = null; only 0 = 0'
4 end "Definitive_Answer"
5 from dual
6 /
Definitive_Answer
------------------------
0 not = null; only 0 = 0
Lunatic said:
Zero is really a placeholder for null
I believe the above example addresses this assertion.
m-w.com said:
the arithmetical symbol 0 or <null> denoting the absence of all magnitude or quantity
M-W.com is imprecise in the above notion. The above example debunks the notion that 0 is somehow equal to NULL.
Lunatic said:
...Zero isn't a true number, not in the sense of 1 to (infinity - 1). Over time it has been 'labeled' a number, but it really is a placeholder for the absence of a true number.
The accepted method of graphically representing the set of all numbers is a number line (e.g. "x axis" on a graph) that extends infinitely to the right for all positive numbers and infinitely to the left for all negative numbers. The integral
number value that is the numeric threshold between negative and positive numbers is the
number zero. I believe that all reputable mathmaticians would unanimously contend that zero is as valid a number value as 1, -1, or any other numeric value.
Lunatic, IMHO, the dictionary entries in your post, above, from m-w.com and wikipedia.org, do not support your assertion that "Zero isn't a true number". In fact, your Wikipedia excerpt
declares that zero is a number:
Wikipedia said:
(zero) is both a number and a numerical digit used to represent that number in numerals. As a number, zero means nothing — an absence of other values.
Wiki's assertion, unfortunately, is imprecise. When Wiki says "zero means nothing", that is extremely ambiguous because
zero does mean something. Additionally, Wiki says, "zero (is)...an absence of other values"; that, too, is ambiguous: "1" is an absence of other values; "285" is an absence of other values, "-1,444" is an absence of other values. Wiki's is a poorly worded, imprecise treatment of
the number "zero".
I also believe that you are presenting only the part of independent definitions that seem to agree with your assertions. It's true that Merriam-Webster says of "zero" what you posted, but you omitted the adjacent definition that unequivocably declares that
zero is a number:
M-W.com said:
Main Entry: ze·ro
Pronunciation: 'zE-(")rO, 'zir-(")O
Function: noun...
1 a : the arithmetical symbol 0 or <null> denoting the absence of all magnitude or quantity b: the number between the set of all negative numbers and the set of all positive numbers
So, once the evidence is in, then:
1) zero is a valid number, and
2) zero is not null.
![[santa] [santa] [santa]](/data/assets/smilies/santa.gif)
Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services:
www.dasages.com]