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

Function: addrasterconstraints

Schema

public

Owner

postgres

Descriptions

args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice.

Options

Definition

CREATE OR REPLACE FUNCTION public.addrasterconstraints (
 rastschema name,
 rasttable name,
 rastcolumn name,
 srid boolean = true,
 scale_x boolean = true,
 scale_y boolean = true,
 blocksize_x boolean = true,
 blocksize_y boolean = true,
 same_alignment boolean = true,
 regular_blocking boolean = false,
 num_bands boolean = true,
 pixel_types boolean = true,
 nodata_values boolean = true,
 out_db boolean = true,
 extent boolean = true
)
RETURNS boolean AS
$span$
DECLARE
constraints text[];
BEGIN
IF srid IS TRUE THEN
constraints := constraints || 'srid'::text;
END IF;

IF scale_x IS TRUE THEN
constraints := constraints || 'scale_x'::text;
END IF;

IF scale_y IS TRUE THEN
constraints := constraints || 'scale_y'::text;
END IF;

IF blocksize_x IS TRUE THEN
constraints := constraints || 'blocksize_x'::text;
END IF;

IF blocksize_y IS TRUE THEN
constraints := constraints || 'blocksize_y'::text;
END IF;

IF same_alignment IS TRUE THEN
constraints := constraints || 'same_alignment'::text;
END IF;

IF regular_blocking IS TRUE THEN
constraints := constraints || 'regular_blocking'::text;
END IF;

IF num_bands IS TRUE THEN
constraints := constraints || 'num_bands'::text;
END IF;

IF pixel_types IS TRUE THEN
constraints := constraints || 'pixel_types'::text;
END IF;

IF nodata_values IS TRUE THEN
constraints := constraints || 'nodata_values'::text;
END IF;

IF out_db IS TRUE THEN
constraints := constraints || 'out_db'::text;
END IF;

IF extent IS TRUE THEN
constraints := constraints || 'extent'::text;
END IF;

RETURN AddRasterConstraints($1, $2, $3, VARIADIC constraints);
END;
$span$
LANGUAGE 'plpgsql'
VOLATILE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;

COMMENT ON FUNCTION public.addrasterconstraints(rastschema name, rasttable name, rastcolumn name, srid boolean, scale_x boolean, scale_y boolean, blocksize_x boolean, blocksize_y boolean, same_alignment boolean, regular_blocking boolean, num_bands boolean, pixel_types boolean, nodata_values boolean, out_db boolean, extent boolean)
IS 'args: rastschema, rasttable, rastcolumn, srid=true, scale_x=true, scale_y=true, blocksize_x=true, blocksize_y=true, same_alignment=true, regular_blocking=false, num_bands=true, pixel_types=true, nodata_values=true, out_db=true, extent=true - Adds raster constraints to a loaded raster table for a specific column that constrains spatial ref, scaling, blocksize, alignment, bands, band type and a flag to denote if raster column is regularly blocked. The table must be loaded with data for the constraints to be inferred. Returns true of the constraint setting was accomplished and if issues a notice.';

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