[postgis-devel] [PostGIS] #1404: [raster] raster2pgsql overviews don't look right

[PostGIS]

#1404: [raster] raster2pgsql overviews don't look right
-----------------------------+----------------------------------------------
  Reporter:  robe            |       Owner:  pracine      
      Type:  defect          |      Status:  reopened     
  Priority:  medium          |   Milestone:  PostGIS 2.0.0
 Component:  postgis raster  |     Version:  trunk        
Resolution:                  |    Keywords:               
-----------------------------+----------------------------------------------

Comment(by robe):

 Let me try again.
 {{{
 -- returns 4, 0 SELECT Count(o2.rast) AS bbox_inter

     , COUNT(CASE WHEN ST_Intersects(o.rast, o2.rast) THEN 1 ELSE NULL END)
 As inter

     FROM boston_test_125_125_Y As o INNER JOIN

         o_2_boston_test_125_125_Y AS o2 ON o.rast && o2.rast

 WHERE ST_Intersects(o.rast, ST_SetSRID(ST_Point(231724, 886309), 26986));

 -- returns 4,4 SELECT Count(o2.rast) AS bbox_inter

     , COUNT(CASE WHEN ST_Intersects(o.rast, o2.rast) THEN 1 ELSE NULL END)
 As inter

     FROM boston_test_200_200_Y As o INNER JOIN

         o_2_boston_test_200_200_Y AS o2 ON o.rast && o2.rast

 WHERE ST_Intersects(o.rast, ST_SetSRID(ST_Point(231724, 886309), 26986));
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1404#comment:23>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.