[postgis-devel] [PostGIS] #1005: [raster] Problem with ST_SummaryStats(text, text) results

PostGIS trac at osgeo.org
Wed Jun 8 12:05:25 PDT 2011


#1005: [raster] Problem with ST_SummaryStats(text, text) results
----------------------------+-----------------------------------------------
 Reporter:  pracine         |       Owner:  dustymugs    
     Type:  defect          |      Status:  assigned     
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by robe):

 I suspect in your first one, the planner has decided not to materialize
 the subselect.

 Interesting to see what would happen if you did something like:


 {{{
 SELECT (ss).*
 FROM (SELECT st_summarystats(rast) ss
       FROM srtm_22_03_tiled_100x100
       OFFSET 0) foo
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1005#comment:9>
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.


More information about the postgis-devel mailing list