That's the way Oracle does it too. http://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_6014.htm
Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems ________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Doug Currie [doug.cur...@gmail.com] Sent: Thursday, June 28, 2012 3:15 PM To: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] how to build sqlite4 (four)? On Jun 28, 2012, at 4:05 PM, Nico Williams wrote: > It's also possibly a good idea to just not have autoincrement. Let > the application implement it, no? After all, it can, including via > triggers. Or with PostgreSQL-style sequences http://www.postgresql.org/docs/9.1/static/sql-createsequence.html (and maybe SERIAL http://www.postgresql.org/docs/9.1/static/datatype-numeric.html#DATATYPE-SERIAL ) e _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users