tvdien wrote:
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...
Mark Rotteveel answers:
Just like in Firebird 2.1 and 2.5, using the SQL standard:
INSERT INTO example DEFAULT VALUES;