[postgis-devel] ST_Value performance

[Pierre Racine]

> It would take a set of (x,y,band,value) or (geometry,band,value) in input and
> incrementally transform a raster to set the values.
> 
> Didn't really think about how you can initialize an aggregate function to provide
> a target dimension for the output raster.

I don't know how ST_AsRaster react when you pass it a point. If it produce a 1 pixel raster (that's what I would expect) then you could try:

SELECT ST_Union(ST_AsRaster(geometry, alignment info,...))
FROM your table