GLHI Database HTML Dump
Previous topic Chapter index Next topic

Function: linefromtext

 

 

Schema

public

 

Owner

wetlands

 

Descriptions

There is no description for function linefromtext

 

Options

Option

Value

Returns

public.geometry

Language

sql

Parameters

text

integer

 

Definition


CREATE OR REPLACE FUNCTION "public"."linefromtext" (text, integer) RETURNS "public"."geometry" AS
$body$
SELECT CASE WHEN geometrytype(GeomFromText($1, $2)) = 'LINESTRING'
	THEN GeomFromText($1,$2)
	ELSE NULL END
$body$
LANGUAGE 'sql' IMMUTABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;

Pete Giencke
pgiencke@glc.org
Previous topic Chapter index Next topic