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