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
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
