Hello
Env.: sqlite 2.8.15 windows, mingw, C interf., table "Gosp" with "pow
integer" column.
Present rows with pos={1.20, 1.32, 430}.

Using sqlite.exe:
SELECT * FROM Gosp WHERE pow >= 1.30 AND pow <= 2.00
...|1.32
SELECT * FROM Gosp WHERE pow > 1.30
...|1.32
...|430

Using C api:
SELECT * FROM Gosp WHERE pow>=1.30 AND pow<=2.00
I get rows with pow = 1.20 and with pow = 1.32
SELECT * FROM Gosp WHERE pow>1.30
I get row with pow = 1.32 only

What's going on? Should I upgrade or something?
Quoting numbers doesn't change anything, neither replacing >=1.30 with 1.3

---
"Most standards acquire funkiness as they age."
www.everything2.com

Reply via email to