SQLite Forum

Error: near "returning": syntax error
Login
$ sqlite3
SQLite version 3.30.0 2019-10-04 15:03:17
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> create table test(id integer primary key);
sqlite> insert into test default values returning id;
Error: near "returning": syntax error
sqlite> 


Guess I need an upgrade.