Hi Tim,
You could try to define your column in the following way to get what you
want
create table t1(a int as casewhen(a is null, 1, a))
Now column a is not defined as not null but it can never get any null
values and thus in practice is "not null".
And you can insert nulls but get the default value instead (which in my
example is 1).
- 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.
