Databasen - NULL dates

David Cantrell david at
Wed Oct 18 15:35:43 BST 2006

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).
> 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.

More information about the mailing list