No, you are wrong. For me, from my point of view, this thread is finished.Looks like you were wrong again.
Don't ask and I will not be responding.
No Scott, that's NOT how math works.Not on planet Albert anyway.
That's how a half-breed intellectual works.And a dash of casual racism, nice. Keep it up you are really impressing people here.
x - xCONCLUSION: since x is unknown, (x - x) is also unknown.
(unknown) - (unknown)
CONCLUSION: since x is unknown, (x - x) is also unknown.Yes.
I'd say that (x - x) is always zero regardless of whether x is KNOWN or UNKNOWN.I am assuming here you are using NULL and UNKNOWN interchangeably and that they are equivalent. So if you say
Well, you can argue with this guy.I've just done it. Guy is OK. Here is his conclusion:
Does Infinity describe a value? OF COURSE NOT! As inAnd if you cannot grok that, you will simply just
that case we will have the flawed concept of
(Infinity+1). Infinity describes a state. Not a
Just like NULL.
For the same reasons that (Infinity - Infinity) !=
0, so too (NULL - NULL) != 0.
What is domain of attribute (column) "AGE" in an employees table?The problem with your explanation here is that you are mixing database level concepts and business level concepts. Just because you create a column on your database that is called age, this will simply be a numeric datatype. The database has no concept of what "age" is and doesn't know that 250 would be an unreasonable value. The domain of reasonable values is something that is determined by business logic that is applied at a level above the database level. As far as the database is concerned if a value isn't entered for the age then it is just "unknown", not "partially unknown" or "totally unknown", just plain old "unknown". You obviously have some understanding of programming concepts but obviously a total lack of understanding or confusion when it comes to systems design concepts.
I'd say 18-65 ages. If a scalar is UNKNOWN, is it "totally unknown" or
just "partially unknown"? I'd say partially, since we exactly know that
250 years old man cannot be an employee in our company.
I'd say that (x - x) is always zero regardless ofYou might say that, but you would be wrong.
whether x is KNOWN or UNKNOWN.