[postgis-users] sum or not sum..

[Chris Hermansen]

Hola Gustavo;

you have no table join condition in the latter so you are doing some
kind of cartesian product?

Gustavo Ces wrote:
> 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>   


-- 
Regards,

Chris Hermansen · mailto:clh at timberline.ca
tel:+1.604.714.2878 · fax:+1.604.733.0631
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5

C'est ma façon de parler.