Changes between Version 89 and Version 90 of WKTRaster/SpecificationWorking01


Ignore:
Timestamp:
12/21/09 14:14:02 (15 years ago)
Author:
pracine
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • WKTRaster/SpecificationWorking01

    v89 v90  
    273273 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:
    274274
    275  CREATE TYPE geomval AS (geom geometry, val float8);
     275 CREATE TYPE geomval AS (geom geometry, val float8);[[BR]]
    276276 CREATE TYPE wktgeomval AS (wktgeom text, val float8);
    277277
    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]]
    280280 $$ LANGUAGE SQL;
    281281