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

Function: postgis_type_name

Schema

public

Owner

albenard

Descriptions

There is no description for function postgis_type_name

Options

Definition

CREATE OR REPLACE FUNCTION public.postgis_type_name (
 geomname varchar,
 coord_dimension integer,
 use_new_name boolean = true
)
RETURNS varchar AS
$span$
SELECT CASE WHEN $3 THEN new_name ELSE old_name END As geomname
FROM
( VALUES
('GEOMETRY', 'Geometry', 2) ,
('GEOMETRY', 'GeometryZ', 3) ,
('GEOMETRY', 'GeometryZM', 4) ,
('GEOMETRYCOLLECTION', 'GeometryCollection', 2) ,
('GEOMETRYCOLLECTION', 'GeometryCollectionZ', 3) ,
('GEOMETRYCOLLECTIONM', 'GeometryCollectionM', 3) ,
('GEOMETRYCOLLECTION', 'GeometryCollectionZM', 4) ,

('POINT', 'Point',2) ,
('POINTM','PointM',3) ,
('POINT', 'PointZ',3) ,
('POINT', 'PointZM',4) ,

('MULTIPOINT','MultiPoint',2) ,
('MULTIPOINT','MultiPointZ',3) ,
('MULTIPOINTM','MultiPointM',3) ,
('MULTIPOINT','MultiPointZM',4) ,

('POLYGON', 'Polygon',2) ,
('POLYGON', 'PolygonZ',3) ,
('POLYGONM', 'PolygonM',3) ,
('POLYGON', 'PolygonZM',4) ,

('MULTIPOLYGON', 'MultiPolygon',2) ,
('MULTIPOLYGON', 'MultiPolygonZ',3) ,
('MULTIPOLYGONM', 'MultiPolygonM',3) ,
('MULTIPOLYGON', 'MultiPolygonZM',4) ,

('MULTILINESTRING', 'MultiLineString',2) ,
('MULTILINESTRING', 'MultiLineStringZ',3) ,
('MULTILINESTRINGM', 'MultiLineStringM',3) ,
('MULTILINESTRING', 'MultiLineStringZM',4) ,

('LINESTRING', 'LineString',2) ,
('LINESTRING', 'LineStringZ',3) ,
('LINESTRINGM', 'LineStringM',3) ,
('LINESTRING', 'LineStringZM',4) ,

('CIRCULARSTRING', 'CircularString',2) ,
('CIRCULARSTRING', 'CircularStringZ',3) ,
('CIRCULARSTRINGM', 'CircularStringM',3) ,
('CIRCULARSTRING', 'CircularStringZM',4) ,

('COMPOUNDCURVE', 'CompoundCurve',2) ,
('COMPOUNDCURVE', 'CompoundCurveZ',3) ,
('COMPOUNDCURVEM', 'CompoundCurveM',3) ,
('COMPOUNDCURVE', 'CompoundCurveZM',4) ,

('CURVEPOLYGON', 'CurvePolygon',2) ,
('CURVEPOLYGON', 'CurvePolygonZ',3) ,
('CURVEPOLYGONM', 'CurvePolygonM',3) ,
('CURVEPOLYGON', 'CurvePolygonZM',4) ,

('MULTICURVE', 'MultiCurve',2 ) ,
('MULTICURVE', 'MultiCurveZ',3 ) ,
('MULTICURVEM', 'MultiCurveM',3 ) ,
('MULTICURVE', 'MultiCurveZM',4 ) ,

('MULTISURFACE', 'MultiSurface', 2) ,
('MULTISURFACE', 'MultiSurfaceZ', 3) ,
('MULTISURFACEM', 'MultiSurfaceM', 3) ,
('MULTISURFACE', 'MultiSurfaceZM', 4) ,

('POLYHEDRALSURFACE', 'PolyhedralSurface',2) ,
('POLYHEDRALSURFACE', 'PolyhedralSurfaceZ',3) ,
('POLYHEDRALSURFACEM', 'PolyhedralSurfaceM',3) ,
('POLYHEDRALSURFACE', 'PolyhedralSurfaceZM',4) ,

('TRIANGLE', 'Triangle',2) ,
('TRIANGLE', 'TriangleZ',3) ,
('TRIANGLEM', 'TriangleM',3) ,
('TRIANGLE', 'TriangleZM',4) ,

('TIN', 'Tin', 2),
('TIN', 'TinZ', 3),
('TIN', 'TinM', 3),
('TIN', 'TinZM', 4) )
As g(old_name, new_name, coord_dimension)
WHERE (upper(old_name) = upper($1) OR upper(new_name) = upper($1))
AND coord_dimension = $2;
$span$
LANGUAGE 'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 200;

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