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
