On 23 Jul 2009, at 4:56pm, Rich Shepard wrote: > 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.
Agreed. And note that if you have a column which is an integer that has doesn't allow duplicates, SQLite will automatically use that column as the one it uses for _rowid_, etc.. So define your own integer column, feed it whatever integers you want, and you won't waste any space. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users