> what value is the setNull method in PreparedStatement?
Value NULL obviously. Some say NULL is not a value but a placeholder for
a proper value.
But in practice it is treated as a value whose type is compatible with
all other types (it's type is supertype of all other types unless the
type explicitly excludes the null value from it's set of values).
I find it a good decision in H2 to omit the value UNKNOWN.
It is worth mentioning that
- if where expression evaluates to null it is treated as not matching
the row.
- if check constraint evaluates to null it is considered as
passing/matching the check constraint.
- 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.
