Michael Scharf <[EMAIL PROTECTED]> wrote: > I make the assumption that items added > in order to a table have their OID in that order > (this is true in sqlite 3.2.7). > > This work fine currently. The question is, is this an artifact > of the current implementation or can I rely on this in the > future? (I know that's not compatible with the SQL specs) >
I cannot guarantee that this will always be tree. But it has always been true for SQLite version 3 and has been true for SQLite version 2 since like version 2.2.0. And I cannot think of a reason that it might change. -- D. Richard Hipp <[EMAIL PROTECTED]>