Re: rtree value rounding

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@...
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users