Found it by myself: insert into test.triggerlog; Reading documentation helps ....

Gesendet: Dienstag, 28. April 2015 um 18:39 Uhr Von: "Robert Koch" An: users-list@monetdb.org Betreff: INSERT DEFAULT values only

How can I insert a row with default values only?

CREATE TABLE test.tbl1 ( id bigint DEFAULT NEXT VALUE FOR "my_test_seq" NOT NULL, instime DATE DEFAULT now() NOT NULL );

Both insert into test.triggerlog (id) VALUES (10000); and insert into test.triggerlog (instime) VALUES (now()); work.

Neither insert into test.triggerlog (id, instime) VALUES (DEFAULT, DEFAULT); nor insert into test.triggerlog (id, instime) VALUES (); work.

What is the correct statement?

Thank you. _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list