> "You can access the ROWID of an SQLite table using one the special column > names ROWID, _ROWID_, or OID. Except if you declare an ordinary table column > to use one of those special names, then the use of that name will refer to > the declared column not to the internal ROWID." > > which suggests that referring to rowids is fine.
It does not suggest referring to ROWIDs is fine, it only says that it can be done. I think Pavel's point is that referencing ROWIDs is bad practice, so that is why he says you shouldn't do it. -- Rich _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users