[postgis-users] sum or not sum..

Gustavo Ces g.ces at pettra.es
Thu Feb 7 07:34:54 PST 2008

Hi all,

    I´ve got two tables with geoms. When i try to sum(area) something strange happens:

select sum(area(the_geom)) from orig1


select sum(area(the_geom))from orig2


but now...

select sum(area(a.the_geom)) as sum1,sum(area(b.the_geom))as sum2 from orig1 a,orig2  b

sum1                        sum2
11218169.9258333     4963426.29935503

smells like postgresql basic concept unknowed for me.... :(

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080207/b4cbde6a/attachment.html>

More information about the postgis-users mailing list