|Subject||Re: [firebird-support] Re: Check and null values|
At 09:27 AM 20/04/2005 +0000, you wrote:
> >That's not what I said.
> > 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.
>AlexanderThks, will fix it.
>Ps: Something different, and I do not know where to ask/mention. This
>groep shows http://firebirdsql.org as website, that url doesn't work.