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

Function: st_mpolyfromtext

 

 

Schema

public

 

Owner

albenard

 

Descriptions

args: WKT, srid - Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not give, it defaults to 0.

 

Options

Option

Value

Returns

public.geometry

Language

sql

Parameters

text

integer

 

Definition

CREATE OR REPLACE FUNCTION public.st_mpolyfromtext (
 text,
 integer
)
RETURNS public.geometry AS
$span$
SELECT CASE WHEN public
.geometrytype(public.ST_GeomFromText($1, $2)) = 'MULTIPOLYGON'
THEN public.ST_GeomFromText($1,$2)
ELSE NULL END
$span$
LANGUAGE
'sql'
IMMUTABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST
100;

COMMENT ON FUNCTION public.st_mpolyfromtext(text, integer)
IS 'args: WKT, srid - Makes a MultiPolygon Geometry from WKT with the given SRID. If SRID is not give, it defaults to 0.';

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