On 2013/12/20 14:09, Simon Slavin wrote:
On 20 Dec 2013, at 12:05pm, Dan Kennedy <danielk1...@gmail.com> wrote:
"1 OR unknown" is not unknown, it is 1. And so on. To summarize:
sqlite> SELECT (0 AND NULL), (1 AND NULL), (0 OR NULL), (1 OR NULL);
0|null|null|1
Well if you're so smart,
(A) Anything divided by itself is 1.
(B) Anything divided by zero is infinity.
(C) What is 0 / 0 ?
There. That should keep you busy through the new year break.
Heh - Sqlite fun threads for christmas!
Of course A and B above are not the only mathematical rules in existence. 0 / 0 is called indeterminate since there is no possible
value x where ( x * 0 ) =/= 0. Of course the axiomatic equation:
x * 0 = 0
can be re-shuffled to show that:
0 = 0 / x
when dividing by x both sides, but when dividing by 0 both sides it yields:
0 / 0 = x / 0
which means x has to be zero for any value of x, which is itself contradictory and cannot ever be the case - and it also
illuminates the reason why 0 / 0 = 1 can never be assumed.
What phased me more was the day my school teacher (eons ago) tried to explain
why:
x ^ 0 = 1 for any x...
Personally I found this much harder to swallow than the indeterminate form of
0/0. :)
Well... that was the better part of 4 minutes... We'll need a few more
conundrums to breach the new-years break, let's have it!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
