As ROWID is often an alias for an integer primary key then it needs to be able to represent both negaitive and positive integers other wise you restrict the range of an integer PK.
Paul www.sandersonforensics.com SQLite Forensics Book <https://www.amazon.co.uk/dp/ASIN/1980293074> On 9 June 2018 at 13:03, Kevin Benson <kevin.m.ben...@gmail.com> wrote: > On Sat, Jun 9, 2018 at 7:03 AM Luuk <luu...@gmail.com> wrote: > > > > > In the docs (https://www.sqlite.org/autoinc.html) it says: > > In SQLite, table rows normally have a 64-bit signed integer ROWID > > <https://www.sqlite.org/lang_createtable.html#rowid> .... > > > > Question: > > Why it this a signed integer, and not an unsigned integer? > > > > Simply by choice? of is there something more to say about this? > > > > http://sqlite.1065341.n5.nabble.com/Use-of-AUTOINCREMENT-td74775.html# > a74786 > -- > -- > -- > --Ö¿Ö-- > K e V i N > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users