[postgis-devel] [PostGIS] #985: [raster] ST_Count

[PostGIS]

#985: [raster] ST_Count
-----------------------------+----------------------------------------------
  Reporter:  dustymugs       |       Owner:  dustymugs    
      Type:  task            |      Status:  reopened     
  Priority:  medium          |   Milestone:  PostGIS 2.0.0
 Component:  postgis raster  |     Version:  trunk        
Resolution:                  |    Keywords:  history      
-----------------------------+----------------------------------------------

Comment(by dustymugs):

 I don't know if it is possible to provide some sort of plpgsql wrapper
 that would do

 {{{
 SELECT ST_Sum(rast), ST_Mean(rast) FROM mytable}}}
 }}}

 as one ST_SummaryStats(rast) under the hood.  I suppose there might be a
 way to have the backend cache the stats for only the duration of the
 transaction but this may get ugly when dealing with a large coverage table
 as each tile's stats would be cached.

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