Changes between Version 89 and Version 90 of WKTRaster/SpecificationWorking01
- Timestamp:
- 12/21/09 14:14:02 (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
WKTRaster/SpecificationWorking01
v89 v90 273 273 To avoid linking directly with PostGIS (see "Why avoid to link with PostGIS?" below) It should be implemented as a SQL wrapper around ST_AsWKTPolygon() looking something like this: 274 274 275 CREATE TYPE geomval AS (geom geometry, val float8); 275 CREATE TYPE geomval AS (geom geometry, val float8);[[BR]] 276 276 CREATE TYPE wktgeomval AS (wktgeom text, val float8); 277 277 278 CREATE OR REPLACE FUNCTION ST_AsPolygon(rast raster) RETURNS SETOF geomval AS $$ 279 SELECT ST_GeomFromText(wktgeomval.wktgeom), wktgeomval.val FROM ST_AsWKTPolygon(%1) AS wktgeomval; 278 CREATE OR REPLACE FUNCTION ST_AsPolygon(rast raster) RETURNS SETOF geomval AS $$[[BR]] 279 SELECT ST_GeomFromText(wktgeomval.wktgeom), wktgeomval.val FROM ST_AsWKTPolygon(%1) AS wktgeomval;[[BR]] 280 280 $$ LANGUAGE SQL; 281 281