"Sergej Schwarz" <sergej.schw...@gmx.de> wrote in message news:20090122133954.74...@gmx.net > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
