Databasen - NULL dates
david at cantrell.org.uk
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).
> >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', ...),
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 london.pm