|Subject||[FB3] Inserting into a table with only an identity column|
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...