On 11/11/2013 12:36 AM, Igor Korot wrote:
Well from strictly mathematical point of view maximum or minimum of nothing is nothing. And since nothing is 0, than it is zero. Thank you.
max() can't simply pull 0 out of the air, for it 0 is the same random number as 1e-129 which might be also considered 0 if only 128 decimal digits are significant to you.
SELECT produce empty set which is nothing in algebra of sets, max() produce scalar value where nothing is undefined if you're looking at numbers. Hence max() on empty set produce NULL, which is nothing in SQL.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
