[postgis-users] raster: several DTM in same table, how to select?

[Denis Rouzaud]

Hi all,

I have a table in which I put ~10 dtm as rasters.

How do I select in the where close the DTM in which my point is?

Indeed, if I use ST_Value on the whole table, I have:
NOTICE:  Attempting to get pixel value with out of range raster 
coordinates: (9512, 9899)
CONTEXT:  PL/pgSQL function "st_value" line 13 at RETURN
SQL statement "SELECT ST_Value(rast, ST_SetSRID( point , 21781 )) FROM 
distribution.dtm"

BTW, isn'it strange? I think that it used to return a NULL value if 
outside of the boundaries, no?


Thanks

Denis