Subject Re: [firebird-support] Re: Check and null values
Author Helen Borrie
At 09:27 AM 20/04/2005 +0000, you wrote:

> >
> > CHECK (TheValue is null or TheValue in (1,2)). Of course, this check
> > constraint is not valid if the column TheValue is declared as NOT NULL.
>Thanx for the info, so if I insert the null in all my checks I wont
>have any conflicts between NOT NULL on the column and the NULL in the
>check, and NOT NULL is always evaluated before the check? The erd tool
>we use has globaly declared check constraints. So that would save me
>some time editing the schema.

That's not what I said.

>Ps: Something different, and I do not know where to ask/mention. This
>groep shows as website, that url doesn't work.
> does.

Thks, will fix it.