Subject | Re: [firebird-support] Re: Illegal use of keyword VALUE |
---|---|
Author | Ann W. Harrison |
Post date | 2006-03-30T16:25:47Z |
olaf_bredv wrote:
less that zero. More important, zero is not equivalent to null.
Null is a state that applies to a field where the value is
unknown. Not knowing how many euros you've got in your pocket
is different from knowing that you have none.
Regards,
Ann
> I think the "integer check(value>0)" is not allowed.No, not quite. In SQL, integers are signed, so they can be
> If you write "CANTIDAD INTEGER NOT NULL" the value must be greater
> then null or 0
> At Integer there is no difference between null and 0.
less that zero. More important, zero is not equivalent to null.
Null is a state that applies to a field where the value is
unknown. Not knowing how many euros you've got in your pocket
is different from knowing that you have none.
Regards,
Ann