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