On Thu, 23 Jul 2009, Shaun Seckman (Firaxis) wrote: > Is it possible in the create a table where the rowid > will start at 0 instead of 1 prior to inserting a row and explicitly > stating that the rowid is 0?
Shaun, Using rowid for anything is not a good idea. There's no guarantee that the column values associated with each rowid are static. It's much better to ignore the rowid and use either a natural primary key or a defined one. Rich -- Richard B. Shepard, Ph.D. | Integrity Credibility Applied Ecosystem Services, Inc. | Innovation <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users