Re: teaching relational basics to people, questions
Date: Sat, 21 Nov 2009 10:24:20 -0600
> [snip] And since
> one would have to have a bona fide range datatype, building in
> handling for infinite ranges would also be easy; that'd get rid of one
> of the most persistent reasons why people incorporate nulls into
I think you are being excessively optimistic. The most persistent (and most common) reason people incorporate nullable columns into designs is because they have a misplaced desire to minimize the number of tables in the design, and think that conflating multiple fact types in one table is clever, efficient, and harmless.
-- RoyReceived on Sat Nov 21 2009 - 17:24:20 CET