Subject | [FB3] Inserting into a table with only an identity column |
---|---|
Author | |
Post date | 2016-12-13T21:05:29Z |
If I have a table like this:
CREATE TABLE EXAMPLE (
E_ID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY
);
How do I add a record to it, getting an automatically assigned ID?
For example, in PostgreSQL, I'd write:
INSERT INTO EXAMPLE(E_ID) VALUES (DEFAULT);
I know such a table doesn't seem very useful, but still...
Thanks!