From 23dc2959b4c04e348f1874e54bf7729cd46a01d1 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Mon, 5 Apr 2010 05:59:46 +0000 Subject: [PATCH] example for st_value git-svn-id: http://svn.osgeo.org/postgis/trunk@5491 b70326c6-7e19-0410-871a-916f4a2858ee --- doc/reference_wktraster.xml | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) diff --git a/doc/reference_wktraster.xml b/doc/reference_wktraster.xml index 209b5fc80..16524709b 100644 --- a/doc/reference_wktraster.xml +++ b/doc/reference_wktraster.xml @@ -569,7 +569,15 @@ srid Examples - + +SELECt rid, ST_Value(rast, 1,1,1) As b1pval, + ST_Value(rast, 2,1,1) As b2pval, ST_Value(rast, 3,1,1) As b3pval +FROM dummy_rast +WHERE rid=2; + + rid | b1pval | b2pval | b3pval +-----+--------+--------+-------- + 2 | 253 | 78 | 70 -- 2.50.1