It looks like to me that CREATE TRIGGER IF NOT EXISTS is recognized by
sqlite, but I get the following from the command line:
sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, value TEXT, timestamp
DATE);sqlite> CREATE TRIGGER IF NOT EXISTS foo_log AFTER INSERT ON foo
BEGIN INSERT INTO foo (timestamp) VALUES (DATETIME('NOW')); END;
SQL error: near "NOT": syntax error
sqlite> CREATE TRIGGER foo_log AFTER INSERT ON foo BEGIN INSERT INTO foo
(timestamp) VALUES (DATETIME('NOW')); END;
sqlite>
Is this expected?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
