SQLite Forum

Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER.
Login
<a href="https://stackoverflow.com/questions/68594144/can-a-real-type-in-sqlite-serve-as-an-alias-for-the-rowid-like-integer-consider">Here is a question asking whether it is possible. </a> I was told no, but no reason was given why this would not be technically feasable. <i>I'd like to imagine that this is a fairly straight forward thing to impliment,</i> because I can not imagine how there could possibly be a technical limitation that would prevent the B-Tree from using the byte signature of a REAL, which is 8 Bytes just like INTEGER.

Hence: <b>Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER.</b>

And if it is not feasible, I am extremely curious as to why it would not be and would love an explanation. Thanks everyone and keep up the good work.