2011/2/16 karsten vennemann <[email protected]>: > [ ... ] > I also have this so far > > update ca.r_model_cells set quad_id = > (select quad.quad_id from ca.quad, ca.r_model_cells > where > quad.merc_geom && r_model_cells.merc_geom > and intersects(quad.merc_geom,r_model_cells.merc_geom));
I think you can get rid of the subquery entirely by using the UPDATE ... SET ... FROM syntax. Something like UPDATE r_model_cells SET quad_id = quad.quad_id FROM quad WHERE intersects(quad.merc_geom, r_model_cells,merc_geom) ; -- T _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
