Hi, as far as I can see from docs, the r-tree extension uses 32-bit floats to store rectangles.
However, when I try to insert this one INSERT INTO points_index (id, x, y) VALUES (3, 731.293, 74.463); i get "SQL error: constraint failed". Reducing the x to 31.293 works. Is the r-tree limitied to WGS84 latitude/longitude coordinates ? In my case, we use cartesian coordinates (such as EUREF89), where coordiates are in meters. Even 32 bit floats may be a limitation here, so question 2: is it easy to modify the code to handle 64-bit doubles instead ? Regards, Oyvind Idland _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users