Dan Kennedy <danielk1977@...> writes: > Probably not. The CREATE TABLE code above actually creates a > 1-dimensional r-tree with deceptive column names. Column "y" contains > the maximum value for the first dimension: > > SQLite version 3.8.5 2014-06-19 12:34:33 > Enter ".help" for usage hints. > Connected to a transient in-memory database. > Use ".open FILENAME" to reopen on a persistent database. > sqlite> CREATE VIRTUAL TABLE abc USING rtree(id,x,y); > sqlite> INSERT INTO abc VALUES(NULL, 20, 10); > Error: constraint failed > sqlite>
I stand corrected. Should have tried this before: sqlite> INSERT INTO abc VALUES(2,30,20); Error: constraint failed Note to self: r-tree is about *ranges* in 1 to 5 dimensions. Wolfgang _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users