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