OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.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?
>
>Thanks,
>
>Edson Richter
>

MaxDB accepts null values for constraint columns, if the constraint does.
Example :

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.

Best Regards,
Thomas
 

  • application/x-pkcs7-signature attachment: smime.p7s