Re: NULL or 0 for a "FLAG

From: Thomas Kellerer <ESPKLFCTEKVY_at_spammotel.com>
Date: Wed, 06 Sep 2006 17:27:43 +0200
Message-ID: <4m87nfF4v2gaU1@individual.net>

On 06.09.2006 17:23 Martin T. wrote:

>> NULL means "undefined".
>> I would _never_ use it to represent an actual "meaningful" value.
>>
>> So, I would always choose option a) together with a check constraint
>> only allowing for 0,1 as the value.
>>

>
> Thomas - thank you.
> Very valid point I guess. (Now that I think more about it, it will for
> example make IF questions on the column value easier.)

Please, take Brian's answer into account as well. He has a very good point about letting the business requirements drive your database model.

Thomas

-- 
It's not a RootKit - it's a Sony

Received on Wed Sep 06 2006 - 10:27:43 CDT

Re: NULL or 0 for a "FLAG_COLUMN"