Found it by myself:
insert into test.triggerlog;
Reading documentation helps ....
Gesendet: Dienstag, 28. April 2015 um 18:39 Uhr Von: "Robert Koch" gms_xy@gmx.de 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