[postgis-users] subqueries in update?

Marc Weber marco-oweber at gmx.de
Fri Apr 13 04:09:05 PDT 2007


On Fri, Apr 13, 2007 at 12:19:59PM +0200, Marc Weber wrote:
> Beeing a total noob I wonder wether I can use suqueries such like 
> update haueser set inside=contains(geomunion( (SELECT the_geom from shape) ),the_geom);

Why do I find the solution after posting? My brain is wired ;)
update haueser set inside=contains( (SELECT geomunion(the_geom) from shape) ,the_geom);
did work



More information about the postgis-users mailing list