Changes between Initial Version and Version 3 of Ticket #348


Ignore:
Timestamp:
Dec 16, 2009, 8:47:37 AM (11 years ago)
Author:
pracine
Comment:

Reformated the query to make the two lines evident.

This bug appears when the coordinates of the center upper left pixel are very precises i.e. -85.750000033333492

A first problem is that the order is different.

A second problem is that the numbers are also different when the precision is high. I guess this problem is related to the fact that bbox are stored as float4s in PostGIS and our version of ST_Envelope returns the float8s version. I think we should return the float4s bbox. I have to test further though.

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #348

    • Property Status changed from new to assigned
  • Ticket #348 – Description

    initial v3  
    1 SELECT ST_AsText(st_raster_envelope(rast)) FROM mytable
    2 UNION ALL
     1SELECT ST_AsText(st_raster_envelope(rast)) FROM mytable[[BR]]
     2UNION ALL[[BR]]
    33SELECT ST_AsText(st_raster_to_box2d(rast)) FROM mytable
    44
    5 should return two identical lines
     5should return two identical lines.