On 2014/09/15 22:13, Simon Slavin wrote:
On 15 Sep 2014, at 8:33pm, Dave Wellman <dwell...@ward-analytics.com> wrote:
Simon,
I'm really surprised at that. Effectively what this means is that the answer
that Sqlite returns may or may not be the correct result.
What ? No. It's correct. The answer is not known, and NULL means "I don't
know". Given that anything divided by 0 is infinity, and anything divided by itself
is 1 what is 0/0 ?
x/0 is of course unknown or, more technically, "undefined" and not simply "infinity" as Simon points out later, and mathematicians
have reasons for this. If anyone has an interest in understanding the real reasons - one of the most succint descriptions of
problems concerning division by zero, 0/0, 0^0, etc. can be found in this youtube video where Dr. James Grime and kie explain some
of the oddities:
http://www.youtube.com/watch?v=BRRolKTlF6Q
And some more interesting information on the History of the number Zero and
whether it is even or not - for those interested:
http://www.youtube.com/watch?v=8t1TC-5OLdM
Happy viewing!
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
