[postgis-devel] [wktraster] Changing the return value of st_value(rast, x, y)

Pierre Racine Pierre.Racine at sbf.ulaval.ca
Wed Jun 2 12:43:46 PDT 2010


Hi,

I think it would be a good idea to change the behavior of st_value(rast, x, y) when the x and y are outside the raster limits. Now it return an error. I think it should instead return a NULL value so that a query does not fail if 1 points on 1000 is outside the raster area.

e.g.

SELECT pointid, rid, st_value(rast, geom) AS rastval
FROM myraster, mypointlayer;

I'll do it if I get no objections.

Pierre




More information about the postgis-devel mailing list