There's already been some correct replies, I'll maybe add that adding 1 in an Int64 number could potentially scale by orders of magnitude in its FP counterpart, so no, it is never possible to be replaced just as-is - to say nothing of the difficulty of making it AUTOINCREMENT. However, if it is FP primary keys you want, there is already a mechanism for that: ``` CREATE TABLE fptable( ID REAL NOT NULL PRIMARY KEY, ... ) WITHOUT ROWID; ``` That's a 100% correct replacement of a int row-id with a float. No shenanigans, no interpreting, no casting, no problems.