Shish writes: > The rtree docs say that as well as 2D geometry, it could be used to > index ranges of time - this is what I'm doing, but I've found a > problem and workaround: > > It seems that the indexed values are stored as a small floating-point > value, and thus large numbers (for example, the current timestamp as > seconds since 1970) will be approximated. The date right now, for > example (1335201433) is rounded to the nearest 128 seconds, [...]
You probably want to use an rtree_i32 virtual table, not an rtree table. Here's a thread that documents my discovery of it. http://osdir.com/ml/sqlite-users/2009-10/msg00280.html g. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users