Databasen - NULL dates

[David Cantrell]

On Wed, Oct 18, 2006 at 01:55:00PM +0100, Andy Armstrong wrote:
> On 18 Oct 2006, at 13:17, Jurgen Pletinckx wrote:
> >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?
> One NULL is never enough - just like undef :)
> If you want to know the reason for nullness that could go in another  
> column - or perhaps another table.

CREATE TABLE fucked_up (
  date_field_is        ENUM('DATE', 'NULL', 'VERY NULL', 'IMAGINARY',
                            'FICTIONAL', 'APPROXIMATE', 'WRONG', ...),
  date_field           VARCHAR(16),
  ...
);

May the database gods strike me down for even considering that.

-- 
David Cantrell | Official London Perl Mongers Bad Influence

You may now start misinterpreting what I just
wrote, and attacking that misinterpretation.