Databasen - NULL dates

Neil de Carteret n3dst4 at gmail.com
Wed Oct 18 11:52:54 BST 2006


> Anyone think of any other alternatives to using NULL?

I wouldn't advocate it, but a second table, the PK of which FKs the
first table.  Then you can do a COUNT() to see if there's a date set
for an entity.  Or a LEFT JOIN, in which case you still get NULLs
returned but at least you're not storing them in the database.

Like I said, I wouldn't advocate it.  As we've all said, this is what
NULLs were made for.

Neil


More information about the london.pm mailing list