Hi, I just wanted to point out a minor discrepancy in the docs below. https://www.sqlite.org/lang_createtable.html#rowid
where it says: If a table contains a user defined column named "rowid", "oid" or "_rowid_", then that name always refers the explicitly declared column and cannot be used to retrieve the integer rowid value. Shouldn't it say at the end "unless that user defined column is an alias for the rowid." For example, you can retrieve the integer rowid value from a user defined column named "rowid" if it defined as the integer primary key: CREATE TABLE t(rowid integer primary key); insert into t values(15); select rowid, oid from t; Results: 15|15 Thanks, Tom _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users