[postgis-users] syntax to pick correct, single result from subquery

[Ture Pålsson]

2011/2/16 karsten vennemann <karsten at terragis.net>:

> [ ... ]
> 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