28 Apr
2015
28 Apr
'15
6:39 p.m.
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.