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

Function: geometrytype

 

 

Schema

topology

 

Owner

albenard

 

Descriptions

There is no description for function geometrytype

 

Options

Option

Value

Returns

text

Language

sql

Parameters

tg topology.topogeometry

 

Definition

CREATE OR REPLACE FUNCTION topology.geometrytype (
 tg topology.topogeometry
)
RETURNS text AS
$span$
SELECT CASE
WHEN type
($1) = 1 THEN 'MULTIPOINT'
WHEN type($1) = 2 THEN 'MULTILINESTRING'
WHEN type($1) = 3 THEN 'MULTIPOLYGON'
WHEN type($1) = 4 THEN 'GEOMETRYCOLLECTION'
ELSE 'UNEXPECTED'
END;
$span$
LANGUAGE
'sql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 26/02/2014 11:51
Previous topic Chapter index Next topic