Hi all,

If I have the following table:

CREATE TABLE stem(sid integer primary key, x double, y double, dbh  
double);

... is there any way I can create an index for the following query?

SELECT * FROM stem WHERE x + dbh > 20

Thanks!
_Nik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to