On 10/9/16, gwenn <gwenn.k...@gmail.com> wrote: > Hello, > I am just looking for information (I am not asking for any change): > It is for (auto) completion hints. > > 1) it seems not possible to insert default values in trigger command: > > // INSERT > trigger_cmd(A) ::= insert_cmd(R) INTO trnm(X) idlist_opt(F) select(S). > > versus > > ////////////////////////// The INSERT command > ///////////////////////////////// > // > cmd ::= with(W) insert_cmd(R) INTO fullname(X) idlist_opt(F) select(S). > cmd ::= with(W) insert_cmd(R) INTO fullname(X) idlist_opt(F) DEFAULT VALUES. > > Is it a choice or an oversight ?
Deliberate. Adding DEFAULT VALUES to triggers is just more code to be tested and maintained for something that adds no new capability and that nobody ever uses. > > Is it to make possible to create temporary trigger by using the > following syntax: > CREATE TABLE test (data); > CREATE TRIGGER temp.trig UPDATE ON main.test BEGIN ...; END; > instead of: > CREATE TEMP TRIGGER trig UPDATE ON main.test BEGIN ...; END; > Did you try it? What happened? -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users