"Don't use a.*, b.*. Instead, explicitly specify the columns you want."
Thanks, I used: CREATE TABLE DensDist AS( SELECT ST_MapAlgebraExpr((ST_MapAlgebraExpr(a.rast,1, '32BF', '[rast]/67.6499557495117')), 1, (ST_MapAlgebraExpr(b.rast,1, '32BF', '[rast]/14052.134765265')), 1, '([rast1] * 0.5) + ([rast2] * 0.3)', '32BF') as rast, 1 as rid FROM density a, euclidean b ); And it produced the result I hoped for. Kind Regards, James ----- GIS Undergraduate -- View this message in context: http://postgis.17.n6.nabble.com/Create-new-table-from-result-of-MapAlgebra-tp4930430p4930528.html Sent from the PostGIS - User mailing list archive at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users