pggeodb.nancy.inra.fr/db_robot - db_robot on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Function: st_reclass

 

 

Schema

public

 

Owner

albenard

 

Descriptions

There is no description for function st_reclass

 

Options

Option

Value

Returns

public.raster

Language

plpgsql

Parameters

rast public.raster

variadic reclassargset public.reclassarg []

 

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 public._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 26/02/2014 11:51
Previous topic Chapter index Next topic