pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr

Function: st_reclass

Schema

public

Owner

postgres

Descriptions

There is no description for function st_reclass

Options

Definition

CREATE OR REPLACE FUNCTION public.st_reclass (
 rast public.raster,
 variadic reclassargset public.reclassarg []
)
RETURNS public.raster AS
$span$
DECLARE
i int;
expr text;
BEGIN
-- for each reclassarg, validate elements as all except nodataval cannot be NULL
FOR i IN SELECT * FROM generate_subscripts($2, 1) LOOP
IF $2[i].nband IS NULL OR $2[i].reclassexpr IS NULL OR $2[i].pixeltype IS NULL THEN
RAISE WARNING 'Values are required for the nband, reclassexpr and pixeltype attributes.';
RETURN rast;
END IF;
END LOOP;

RETURN _st_reclass($1, VARIADIC $2);
END;
$span$
LANGUAGE 'plpgsql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23