On Jun 26, 2009, at 12:22 PM, D. Richard Hipp wrote: > > On Jun 26, 2009, at 12:13 PM, Shaun Seckman (Firaxis) wrote: > >> I have a column ("ID") in a table that is the primary key integer >> so it >> should be an alias for ROWID. Is it safe to have a ROWID of 0? > > > A ROWID can have any value between -9223372036854775808 and > 9223372036854775807, inclusive of both ends and of zero. And, yes, > the boundary values are tested in the test suite. >
I should add, though, that negative ROWIDs each consume 9 bytes of disk space, where as small positive ROWIDs only use 1 or 2 bytes. So non-negative ROWIDs are preferred. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users