Re: teaching relational basics to people, questions

From: Roy Hann <specially_at_processed.almost.meat>
Date: Sat, 21 Nov 2009 10:24:20 -0600
Message-ID: <>

Sampo Syreeni wrote:

> [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
> designs.

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.

Received on Sat Nov 21 2009 - 17:24:20 CET

Original text of this message