You searched for the word(s): 5
Hi again, Andy,
I wrote my previous response to your first contributuon in this thread, before I noticed your second. Here I just want to respond further to this, from you:
"The reason why nulls are GOOD is precisely that the bag functions (e.g.
AVG) which the system provides, are TRAINED to ignore rows containing ...
Hi Andy (and all),
I have to say I intensely dislike the use of the term "religious zealotry" in contexts such as the present. I appreciate your apology (to Ken) and apparent retraction--of the term's usual connotation if not the term itself. Chris Date and I would respond indignantly, claiming that we have put ...
Thanks for promoting this discussion to its own thread. I think that will give it the space it needs to breathe. Also, though, I hope other people will feel free to join in the discussion.
I also like your proposal to take things in small chunks. This will allow us to get to the truth more easily. And btw, ...
Yes I agree with you about splitting the thread so here it is.
I hope you like the title. I was tempted to use "Nulls pour les Nuls" but then I felt that the Shakespearian option would be more informative.
Nulls are indeed a very important question which has hitherto not had the attention it deserves in this forum. So ...
You have my deepest apologies for using language that might be construed, if mistakenly, as a put-down of Chris Date. I myself am a big fan of Mr. Date, whom I regard in precisely the same way as your Amazon reviewer does, and I meant no disrespect in calling him a "religious zealot" -- which, for me, is a term ...
Ken, it sounds like you're proposing that every time we have a fact type that is many-to-one but not mandatory on either side, we should have a new table for it? Because frankly, that does sound like religious nonsense. It's not what Rmap does in this very common case, and that's a good thing too. The original non-mandatory fact type ...
Well, I respect free speech but your characterisation of Chris Date as a "Religeous Zealot" rather contrasts with what Amazon.com says about him which is: "Chris Date is the computer industry's most respected expert and thinker on
[quote user="Andy ...
Good to hear from you. Certainly, there are many religious zealots out there (of whom the generally sagacious Chris Date is one) on the issue of nulls and their advantages or disadvantages. Not to make fun of either side, but I'd be interested in finding anyone who could prove that having nulls causes more problems than does ...
There seems to be an implied "Elephant in the Room" in this thread called "Nulls are OK"
Isn't it the case that relational theory breaks down when missing values (nulls) are encountered in a table?
Of course it seems that there are many RDBMS's out there that contain database instances that include ...
P.S. Sorry for the typo in my hypothetical example, it should have read,
"WHERE blah-blah is NOT null, THEN return such-and-such, ELSE WHERE blip-blip is NOT null, THEN...." <return so-and-so...>