|Subject||Re: [Firebird-Architect] Nulls in CHECK Constraints|
> > What are the opinions about this?<search
> The Firebird behaviour violates the standard.
> > What does the standard say?
> "A table check constraint is satisfied if and only if the specified
> condition> is not False for any row ofI would also say that "not null"-ness is a column constraint, not a
> a table". And Unknown is not False.
> > What do other databases implement?
> PostgreSQL and MSSQL are standard compliant, i.e. they follow the Oracle's
> line of thinking.
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Database development questions? Check the forum!