Hi, the R-tree documentation says: | Attempts to insert something other than an integer into the first | column, or something other than a numeric value into the other | columns, will result in an error.
This is not actually true: > create virtual table t using rtree(id, x1, x2); > insert into t values(null, null, null); > insert into t values('xxx', 'xxx', x'1234'); > select * from t; 1|0.0|0.0 0|0.0|0.0 Regards, Clemens