Re: [sqlite] starting INTEGER PRIMARY KEY at 0

On Mon, Mar 16, 2009 at 10:08 AM, P Kishor wrote: > On Mon, Mar 16, 2009 at 8:59 AM, John Machin wrote: >> On 17/03/2009 12:33 AM, P Kishor wrote: >>> On Mon, Mar 16, 2009 at 8:31 AM, P Kishor wrote: is there a way to have a

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

P Kishor wrote: > > compatibility. And, as 'they' say, 0 is a perfectly fine number. Why > let it go waste. > > Real people always start counting from 1. Only programmers (and the occasional hardware engineer) start counting from 0. We see it so often it starts to seem normal, but it really

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

On Mon, Mar 16, 2009 at 8:59 AM, John Machin wrote: > On 17/03/2009 12:33 AM, P Kishor wrote: >> On Mon, Mar 16, 2009 at 8:31 AM, P Kishor wrote: >>> is there a way to have a table start the INTEGER PRIMARY KEY sequence >>> at 0 (or some other arbitrary

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

On 17/03/2009 12:33 AM, P Kishor wrote: > On Mon, Mar 16, 2009 at 8:31 AM, P Kishor wrote: >> is there a way to have a table start the INTEGER PRIMARY KEY sequence >> at 0 (or some other arbitrary number)? >> >> -- >> Puneet Kishor >> > > I should have added.. yes, I can do

Re: [sqlite] starting INTEGER PRIMARY KEY at 0

On Mon, Mar 16, 2009 at 8:31 AM, P Kishor wrote: > is there a way to have a table start the INTEGER PRIMARY KEY sequence > at 0 (or some other arbitrary number)? > > -- > Puneet Kishor > I should have added.. yes, I can do the following CREATE TABLE foo (a INTEGER PRIMARY

[sqlite] starting INTEGER PRIMARY KEY at 0

is there a way to have a table start the INTEGER PRIMARY KEY sequence at 0 (or some other arbitrary number)? -- Puneet Kishor ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users