[postgis-users] SUM() for lines

Daniel Grum daniel.grum at unibw.de
Wed Aug 26 09:20:26 PDT 2009

Hi all,

how can I sum the atributes of any lines of one column --> how I can sum 
the info of a column.
I want to save all avaible resources(all polygons) in an extra column 
next to the resources of one polygon?!

like this:
gid(integer) | flaeche(double precision) | sum_flaeche(double precision)
2000                                      2000
5000                                      7000
100                                       7100

And how I can select the last info of the column: sum_flaeche to wok 
with the number-->in this case: 7100

If this could not work please describe me another possible way?!


More information about the postgis-users mailing list