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

[Mark Cave-Ayland]

Pierre Racine wrote:

> 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

Looks sensible to me.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs