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

[PostGIS]

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

Comment(by dustymugs):

 Thanks for catching the error with the sum as I forgot to collect the sum
 for coverages.  My next revision will fix that.

 As for the standard deviation of a coverage, I do confirm the issue.  To
 do this correctly will require going over the coverage table twice, once
 for the coverage's mean and the second for the mean's standard deviation.
 So, do we want to be accurate at the expense of speed or be close at the
 expense of accuracy?  Maybe we need to add an option flagging whether or
 not to get the accurate standard deviation for a coverage?

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