On 11 Feb 2013, at 3:01pm, Clemens Ladisch <[email protected]> wrote:
> Igor Tandetnik wrote: >> INTEGER PRIMARY KEY simply introduces a named alias for ROWID; its >> presence doesn't make anything possible that wasn't already possible >> without it. > > If the ROWID isn't 'officially' made part of the table's columns by > declaring some INTEGER PRIMARY KEY, then it can be renumbered by the > next VACUUM. Hmm. In which case you'd still get the rows in the same order, but the values reported for one of the columns could change. Contra-intuitive. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
