Hajo(at)Lemcke(dot)com wrote on 02.05.2013 10:18:
> I would like to have the default value replace a given null value if the
> column is specified with not null and default.
>
> The SQL specification only requires to set the default value when the column
> is omitted on insert or update.
>
> I think this is a flaw in the specification because it requires developers
> to create multiple statements for inserts and updates for all combinations
> of default not null columns.
You can use DEFAULT instead of NULL, no need to have different statements.