"Sergej Schwarz" <[email protected]> wrote in message news:[email protected] > unfortunately, this does not work, the RTree documentation by SQLite > leads to misunderstanding of the concept... The query would results > in an empty set. > > //your query > select * from demo where x1>=3 and x2<=19 and y1>=2 and y2<=15;
That's not at all similar to Dan's query. Try this: select * from demo where x1<=19 and x2>=3 and y1<=15 and y2>=2; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
