tag:blogger.com,1999:blog-25223681.post2712668385012120872..comments2021-10-13T05:02:38.305-05:00Comments on The eye sees only what the mind is prepared to comprehend: Null versus NoneLuxspeshttp://www.blogger.com/profile/16636706720254040664noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-25223681.post-15491552595873975142010-03-15T22:10:43.301-06:002010-03-15T22:10:43.301-06:00Missing information is one dead horse that seems p...Missing information is one dead horse that seems prone to eternal beating. Nulls as embodied in SQL are fraught with danger, but avoiding missing information alltogether is simply not possible because it assumes that discourse always takes place at the database level (where cardinality difference can occur). Special values are essentially a non-starter as a general solution, because they assume that it is even possible or logical to set aside a value in a given type (consider boolean for example).<br /><br />Some thoughts on the subject from a few years back:<br />http://tenwaystosunday.blogspot.com/2006/07/actively-managing-missing-information.html<br />http://tenwaystosunday.blogspot.com/2007/04/condition-propagation-renamed-proviso.htmlNathan Allanhttps://www.blogger.com/profile/16536035662769805976noreply@blogger.com