Hi,
I have a simple table like
CREATE TABLE RecipeIngredients (
id integer primary key,
recipeid integer(10),
unitId integer(10),
...
);
With an index on recipeid and unitid (foreign keys)
In the table there are 11 rows where recipeid is "558134" and 243042 rows
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
Hello
Env.: sqlite 2.8.15 windows, mingw, C interf., table "Gosp" with "pow
integer" column.
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
3 matches
Mail list logo