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!
 

  • [firebird-support] ... tvd...@ymail.com [firebird-support]

Reply via email to