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

Function: _add_raster_constraint_scale

 

 

Schema

public

 

Owner

postgres

 

Descriptions

There is no description for function _add_raster_constraint_scale

 

Options

Option

Value

Returns

boolean

Language

plpgsql

Parameters

rastschema name

rasttable name

rastcolumn name

axis char

 

Definition

CREATE OR REPLACE FUNCTION public._add_raster_constraint_scale (
 rastschema name,
 rasttable name,
 rastcolumn name,
 axis char
)
RETURNS boolean AS
$span$
DECLARE

fqtn text;
cn name;
sql text;
attr double precision;
BEGIN
IF
lower($4) != 'x' AND lower($4) != 'y' THEN
RAISE EXCEPTION
'axis must be either "x" or "y"';
RETURN FALSE;
END IF;

fqtn := '';
IF length($1) > 0 THEN
fqtn := quote_ident($1) || '.';
END IF;
fqtn := fqtn || quote_ident($2);

cn := 'enforce_scale' || $4 || '_' || $3;

sql := 'SELECT st_scale' || $4 || '('
|| quote_ident($3)
|| ') FROM '
|| fqtn
|| ' LIMIT 1';
BEGIN
EXECUTE
sql INTO attr;
EXCEPTION WHEN OTHERS THEN
RAISE NOTICE
'Unable to get the %-scale of a sample raster: % (%)',
       upper($4), SQLERRM, SQLSTATE;
RETURN FALSE;
END;

sql := 'ALTER TABLE ' || fqtn
|| ' ADD CONSTRAINT ' || quote_ident(cn)
|| ' CHECK (round(st_scale' || $4 || '('
|| quote_ident($3)
|| ')::numeric, 10) = round(' || text(attr) || '::numeric, 10))';
RETURN  public._add_raster_constraint(cn, sql);
END;
$span$
LANGUAGE
'plpgsql'
VOLATILE
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
Previous topic Chapter index Next topic