SQLite Forum

Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER.
Login
What about sorting of values when you interpret them as INTEGER? Is it the same as ordering by REAL values?

If no, you still can find row in BTree by key, but can't search by '<',  '>' and so on.
It can be solved, but it will not be "just interpret real as integer".