[postgis-devel] [wktraster] Changing the return value of st_value(rast, x, y)
Mark Cave-Ayland
mark.cave-ayland at siriusit.co.uk
Thu Jun 3 02:11:56 PDT 2010
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
More information about the postgis-devel
mailing list