Changes between Version 89 and Version 90 of WKTRaster/SpecificationWorking01

Timestamp:

Dec 21, 2009, 2:14:02 PM (14 years ago)

Author:

pracine

Comment:

—

WKTRaster/SpecificationWorking01

@@ -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:
 
- CREATE TYPE geomval AS (geom geometry, val float8);
+ CREATE TYPE geomval AS (geom geometry, val float8);[[BR]]
  CREATE TYPE wktgeomval AS (wktgeom text, val float8);
 
- CREATE OR REPLACE FUNCTION ST_AsPolygon(rast raster) RETURNS SETOF geomval AS $$
-     SELECT ST_GeomFromText(wktgeomval.wktgeom), wktgeomval.val FROM ST_AsWKTPolygon(%1) AS wktgeomval;
+ CREATE OR REPLACE FUNCTION ST_AsPolygon(rast raster) RETURNS SETOF geomval AS $$[[BR]]
+     SELECT ST_GeomFromText(wktgeomval.wktgeom), wktgeomval.val FROM ST_AsWKTPolygon(%1) AS wktgeomval;[[BR]]
  $$ LANGUAGE SQL;