Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
AW: CHECK constraint with NULL values
From: Anhaus, Thomas (thomas.anhaussap.com)
Date: Mon Oct 31 2005 - 00:28:40 CST
Edson Richter wrote :
>Why could not MaxDB accept NULL values in columns with CHECK
>constraint? There are any SQL
>standards that dictates this rule (I really never heard about this)?
>Can I fill a request to add this feature?
MaxDB accepts null values for constraint columns, if the constraint does.
create table test (col1 int check col1 > 0)
will not accept null values because null > 0 is not true.
create table test (col1 int check col1 is null or col1 > 0)
will accept null values.
- application/x-pkcs7-signature attachment: smime.p7s