SQLite Forum

Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings)
I don't want to retrieve all of the data into my programs memory if I can at all avoid it, because it could be millions of rows. That's why I'm looking for a solution that executes in SQLite as much as possible.

My integer detecting query seems to work fine in that respect, but I'm checking to see if there are even more efficient queries I can use.