[postgis-devel] Vive Doublebox

[Sandro Santilli]

On Wed, Dec 07, 2011 at 08:32:48AM -0800, Paul Ramsey wrote:

> 'LINESTRING(0 0, 1 1)'::geometry::bbox will be 'BOX(-0.00000001
> -0.00000001, 1.00000001 1.000000001)'

Floats have at most 7 significant digits. Your numbers above would
be 0 and 1 if the printing didn't print 9 instead.

Of course if you then cast back to doubles you'll still get to
see the dust ...

> feels a shame to make a shiny brand new type and have it visibly
> reflect one of the uglier design compromises of the 1.x series.
> 
> I'm tempted to apply the doublebox to trunk, and just commit to trying
> to make it faster over time.

Would indices be also part of this conversion-to-double ? Implications ?

--strk; 

  ,------o-. 
  |   __/  |    Thank you for PostGIS-2.0 Topology !
  |  / 2.0 |    http://www.pledgebank.com/postgistopology
  `-o------'