[postgis-users] ST_SetValue takes too much time..

[Sandro Santilli]

On Mon, Feb 20, 2012 at 04:50:17PM +0100, daniel spiering wrote:

>    UPDATE target_tbl SET rast = ST_SetValue(rast, 1, COL, ROW, CLIMATE_VALUE)
>    WHERE EXTRACT(DOY FROM datum) = CURRENT_DAY;
> 
>    The problem is that updating each cell, using the ST_SetValue-function
...
>    Is there any other way to create rasters from the original data than
>    updating an empty raster cell by cell?

Hi Daniel, I had a similar requirement a few weeks ago, see:
http://postgis.refractions.net/pipermail/postgis-devel/2012-February/018033.html

--strk;