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

Function: droprasterconstraints

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 - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.

Options

Definition

CREATE OR REPLACE FUNCTION public.droprasterconstraints (
 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 = true,
 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 DropRasterConstraints($1, $2, $3, VARIADIC constraints);
END;
$span$
LANGUAGE 'plpgsql'
VOLATILE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;

COMMENT ON FUNCTION public.droprasterconstraints(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 - Drops PostGIS raster constraints that refer to a raster table column. Useful if you need to reload data or update your raster column data.';

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