I guess the rowId is indexed automatically as well?
On 9/14/05, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > R S <[EMAIL PROTECTED]> wrote: > >> I don't quite see why you need rowId to be contiguous to implement > >> your paging. Can't you do something like this: > >> > >> select * from mytable > >> where rowId > :lastRowId > >> order by rowId > >> limit 100 > >> > >> OK I do it this way, but my concern was are these rows refilled > >> later? > > Also what happens if the rowid exceeds U32? > > It is rather difficult to force SQLite into a situation where it assigns > non-increasing ids - essentially, you have to either overflow 64-bit > counter, or explicitly create a row with the id of 2^64-1. If you don't > want to take any chances, declare the column with autoincrement keyword. > For more details, see > > http://www.sqlite.org/autoinc.html > > Igor Tandetnik > >
