h...@lemcke.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.



--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to