Jan Danielsson wrote: > I can't make the rowid a uint32_t, but that's essentially the > behavior I'm looking for
CREATE TABLE transfers ( ID INTEGER PRIMARY KEY CHECK (ID BETWEEN 0 AND 4294967295), [...] ); But if you want the values to wrap around after old ones have been deleted, you have to implement it yourself. (A random search is efficient as long as the set of actually used IDs is sparse.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users