On Thu Oct 09, 2014 at 05:38:57PM -0500, Nico Williams wrote:
> I use triggers, particularly INSTEAD OF INSERT triggers on VIEWs.
> The values of the columns of the rows to be "inserted" are the
> "stored procedure's" arguments.
I would like to able to do this too, but INSTEAD OF INSERT on a view
does not support default values for arguments the same way that BEFORE
INSERT on a regular table does.
What would really be nice is if one could run the following inside a
BEFORE or INSTEAD OF trigger:
UPDATE
NEW
SET
NEW.name = COALESCE(NEW.name, new_value)
;
Could the SQLite team perhaps comment on how difficult this would be to
implement?
--
Mark Lawrence
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
