[postgis-users] raster, stats conditioned to a set of values

[juli g. pausas]

INSERT INTO rastertmp.provanet
    SELECT t1.rid, ST_Union(ST_Intersection(t1.rast, 1, t2.rast, 1,
'BAND1'))
    FROM rastertmp.prova AS t1, rastertmp.provapositiu AS t2
    WHERE ST_Intersects(t1.rast, t2.rast)
    GROUP BY t1.rid;


NOTICE:  The two rasters provided have no intersection.  Returning no band
raster
CONTEXT:  PL/pgSQL function
st_intersection(raster,integer,raster,integer,text,double precision[]) line
20 at assignment
NOTICE:  Could not find raster band of index 1 when setting pixel value.
Nodata value not set. Returning original raster



Juli
--
*CIDE, CSIC*  |  www.uv.es/jgpausas  |


On Mon, Jul 6, 2015 at 3:52 PM, Pierre Racine <Pierre.Racine at sbf.ulaval.ca>
wrote:

> > Adding a GROUP BY t1.rid, doesn't solve the problem, still get an error.
>
> Which error?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20150706/183f207e/attachment.html>