Hi,
In the docs it is stated:"The check condition must evaluate to true or
to |NULL"
Does this mean that the following constraint is not allowed
CONSTRAINT SELF_MUST_NOT_BE_PARENT CHECK (PARENT_ID <> APID)
because it can evaluate to false?
Or is it just that the documentation should say something like this:
|"The check condition must evaluate to true, false or |NULL.
True means that the modification passes the constraint. False and NULL
mean that the modification fails the constraint.
Note: In sql standard NULL <> 1 evaluates to UNKNOWN (a third truth
value) whereas in H2 it evaluates to null (something more obscure)."
- rami
|
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
