On Thu, 2007-07-12 at 23:38 -0700, RohitPatel9999 wrote:
> Hi
>
> I have a Question regarding INTEGER PRIMARY KEY (zero value in column) ?
>
> Example table => create table {id INTEGER PRIMARY KEY, name TEXT};
>
> Is it ever possible that value 0 (zero) will be inserted in a column
> declared as INTEGER PRIMARY KEY (and not as AUTOINCREMENT) ? Inserts are
> always with NULL value for that column. (i.e zero is never inserted
> implicitly in that column)
It's possible. But it's very unlikely. The fifth paragraph of
the following document describes how values are allocated for
integer primary key columns not declared as AUTOINCREMENT
columns:
http://www.sqlite.org/autoinc.html
Dan.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
