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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Regards, Chris Hermansen · mailto:[EMAIL PROTECTED] 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
