<woodbri at swoodbridge.com> wrote:
 >>>> On Fri, Jul 11, 2008 at 9:23 PM, Steve Friedman
 >>>> <sfriedman at woti.com> wrote:
 >>>>> I've just started using the rtree extension, and have found that
 >>>>> the 32-bit
 >>>>> float for the range keys is not appropriate for me.  Please find
 >>>>> attached a
 >>>>> patch for rtree.c (based on v1.5) that allows for int -OR-
 >>>>> unsigned int -OR-
 >>>>> float operation.
 >>
 >> What kind of advantages does using int over float have here?
 >>
 >> With a little work it might be possible to select int or float at
 >> runtime. Do other people who know about such things think that this
 >> would be a good option to have?
 >
 > Dan,
 >
 > I think the need for integer support is to avoid floating point rounding
 > errors that might cause you to miss a key otherwise.
 >
 > I think this would be a nice feature to have. I think it should be
 > implemented at runtime because if I ever have an application that need
 > both say time (int) and spatial rtrees (floats) then it puts me into a
 > problem of not being able to support both in a single build.
 >
 > -Steve

I agree with your desire; however, let's not let the perfect become the 
enemy of the good.  My patch satisfies my initial need.  Can I have that 
included in 3.6.0?  A subsequent patch, with the more complete 
implementation to eliminate compile-time restrictions, could be included 
in a later release.

Steve Friedman

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to