On 2016-12-13 22:05, tvdien@... [firebird-support] 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...

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