> On Jun 28, 2017, at 4:15 PM, R Smith <rsm...@rsweb.co.za> wrote: > > I did ponder whether it would be a nice "feature" to use the default if both > a DEFAULT and a NOT NULL constraint existed on a column - but then again, > that will go against strict design principles and can cause a lot of > confusion later.
Some databases, which we shall not name, provide both options [1]: - DEFAULT for columns without an explicit value - DEFAULT ON NULL for columns with an explicitly null [1] https://oracle-base.com/articles/12c/default-values-for-table-columns-enhancements-12cr1#nulls _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users