Subject [FB3] Inserting into a table with only an identity column
Author

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!