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

Function: addrasterconstraints

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, 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

Option

Value

Returns

boolean

Language

sql

Parameters

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

 

Definition

CREATE OR REPLACE FUNCTION public.addrasterconstraints (
 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$
SELECT public
.AddRasterConstraints('', $1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
$span$
LANGUAGE
'sql'
VOLATILE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.addrasterconstraints(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: rasttable, rastcolumn, srid, scale_x, scale_y, blocksize_x, blocksize_y, same_alignment, regular_blocking, 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 26/02/2014 11:51
Previous topic Chapter index Next topic