I am trying to update my table with the values from a raster stored within the database.
Edit: I've posted the answer bellow: http://gis.stackexchange.com/a/63655/6711
The query I'm trying to use is Q
update data.points_test_10000 set sdi_index = ( select st_value(rast,geom) from rasters.sdi_4326 a, data.points_test_10000 b where a.rast && b.geom ) ;
but I'm getting the error:
more than one row returned by a subquery used as an expression
without the set statments the query works as it should