SQLite Forum

Efficiently checking if a TEXT column exclusively contains integers or floating point numbers (as strings)
Login
Chronological Hierarchical 
Add to your test suite

<code>0
-0.01
-1
-1.01
1e12
-1e12
1e-12
-1e-12
1.1e-12
-1.1e-12
1brick
-1brick</code>