It would be useful as a convenience, particularly on very?long?tables,?so the
user could omit all names and just use a single DEFAULT in the particular
value. It's also easier to programmatically decide whether to insert a DEFAULT,
NULL,?or an alternate value rather than selectively omitting a particular
column.
On Friday, November 20, 2015 3:08 AM, Clemens Ladisch <clemens at
ladisch.de> wrote:
chromedout64 at yahoo.com wrote:
> Is it possible to implement a DEFAULT literal-value in SQLite, which
> would allow an individual column to be populated with a DEFAULT, similar
> to how a NULL or CURRENT_TIMESTAMP is currently used?
What is this needed for, when it is already possible to omit the column
from the names/values lists?? If it is just about documentation, this
could be done just as well with a comment.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
