On 2/10/2013 11:55 PM, Mohit Sindhwani wrote:
I just meant to say that ROWID is not a sequence number of insertion in
the case when an INTEGER PRIMARY KEY is used - it comes across as a
sequence number when we don't have an integer primary key.
I'm pretty sure (but too lazy to check) that you can write something like
insert into MyTable (ROWID, OtherField) values (42, 'xyz');
and mess up your ROWID this way, if you are so inclined. INTEGER PRIMARY
KEY simply introduces a named alias for ROWID; its presence doesn't make
anything possible that wasn't already possible without it.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
