[firebird-support] [FB3] Inserting into a table with only an identity column

[[e-mail] [firebird-support]]

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!

[Mark Rotteveel [e-mail] [firebird-support]]

Post by ***@ymail.com [firebird-support]
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?
&nbsp ; INSERT INTO EXAMPLE(E_ID) VALUES (DEFAULT);
I know such a table doesn't seem very useful, but still...

Just like in Firebird 2.1 and 2.5, using the SQL standard:

INSERT INTO example DEFAULT VALUES

See
http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-dml-insert.html#fblangref25-dml-insert-defaults

Mark

[[e-mail] [firebird-support]]

Missed that; dank je. :)