Databasen - NULL dates

Jonathan Stowe jns at gellyfish.com
Wed Oct 18 20:10:39 BST 2006


On Wed, 2006-10-18 at 13:44 +0100, Nigel Rantor wrote:
> Jurgen Pletinckx wrote:
> > | NULL is the unknown value. Your dates are unknown. Sounds like a  
> > | perfect match to me. I'd be interested in hearing the other point of
> > 
> > | view.
> > 
> > This may just represent fuzzy thinking on my part, but...
> > 
> > I can see where I would be interested in the difference between 
> > as-yet-unknown (will be filled in during one of the next rounds 
> > of data entry) and unknowable (won't ever be filled in, barring 
> > paradigm shift or policy change).
> > 
> > NULL and VERY NULL? 
> > 
> > Or is this standard question nr 27, and did I just flunk?
> 
> Well, let's say we have:
> 
> 1) As yet unknown, will possibly be known in the future (date of death, 
> employee resgination)
> 
> 2) Unknowable (end of the universe)
> 

Wait .... Is this that alternative universe where Donald Rumsfeld and
Ted Codd are one and the same person?

/J\


More information about the london.pm mailing list