[postgis-users] subqueries in update?

[Raphaël Jacquot]

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);
> 
> to set a property of each row indicating that the polygon is inside the union of all polygons of table shape.
> 
> Reading posgres documentation I only could find subqieries in the Where or
> SELECT ... part of a query.
> 
> If not how would you accomplish this task?
> 
> Marc

you wait for some later version

quote from http://www.postgresql.org/docs/faqs.TODO.html
-----
# UPDATE

     * Allow UPDATE tab SET ROW (col, ...) = (SELECT...)

 
http://archives.postgresql.org/pgsql-hackers/2006-07/msg01306.php 	 
  http://archives.postgresql.org/pgsql-hackers/2007-03/msg00865.php
-----

in the meantime, use a stored procedure