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

Function: st_geometrytype

Schema

topology

Owner

albenard

Descriptions

There is no description for function st_geometrytype

Options

Definition

CREATE OR REPLACE FUNCTION topology.st_geometrytype (
 tg topology.topogeometry
)
RETURNS text AS
$span$
SELECT CASE
WHEN type($1) = 1 THEN 'ST_MultiPoint'
WHEN type($1) = 2 THEN 'ST_MultiLinestring'
WHEN type($1) = 3 THEN 'ST_MultiPolygon'
WHEN type($1) = 4 THEN 'ST_GeometryCollection'
ELSE 'ST_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