db_venik
Previous topic Chapter index Next topic

Domain: topoelement

 

 

Schema

topology

 

Owner

postgres

 

Descriptions

postgis domain: An array of 2 integers generally used to identify a TopoGeometry component.

 

Definition

CREATE DOMAIN topology.topoelement AS
 integer[] NULL;

COMMENT ON DOMAIN topology.topoelement
IS 'postgis domain: An array of 2 integers generally used to identify a TopoGeometry component.';

ALTER DOMAIN topology.topoelement
 ADD CONSTRAINT dimensions CHECK ((array_upper(VALUE, 2) IS NULL) AND (array_upper(VALUE, 1) = 2));

ALTER DOMAIN topology.topoelement
 ADD CONSTRAINT lower_dimension CHECK (array_lower(VALUE, 1) = 1);

ALTER DOMAIN topology.topoelement
 ADD CONSTRAINT type_range CHECK ((VALUE)[2] > 0);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic