[postgis-users] sum or not sum..

[Gustavo Ces]

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

61301.4750045538

select sum(area(the_geom))from orig2

33996.0705435276


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.... :(

Gus

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users