D. Richard Hipp wrote: > On Jun 4, 2008, at 7:13 AM, Derrell Lipman wrote: > >> On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp <[EMAIL PROTECTED]> >> wrote: >> >>> Let me strongly reiterate that you look into using the new R-Tree >>> virtual table available for SQLite. R-Trees are specifically >>> designed >>> to do exactly the kind of query you are asking to do. See >>> >>> http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/README&v=1.2 >>> >> The README contains this text: >> >> CREATE VIRTUAL TABLE <name> USING rtree(<column-names>) >> >> For example: >> >> CREATE VIRTUAL TABLE boxes USING rtree(boxno, xmin, xmax, ymin, >> ymax); >> CREATE VIRTUAL TABLE boxes USING rtree(1, 1.0, 3.0, 2.0, 4.0); >> >> Is that last line supposed to be >> INSERT INTO boxes VALUES (1, 1.0, 3.0, 2.0, 4.0); >> ? > > Yes. > http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/README&v=1.3 > > D. Richard Hipp > [EMAIL PROTECTED] > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > In the same document: "For each pair of real values, the first (leftmost) must be less than or greater than the second."
should presumable read "less than or equal to" Thanks SteveK _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users