Schema
Owner
postgres
Descriptions
args: tg - Returns a set of topoelement objects containing the topological element_id,element_type of the given TopoGeometry (primitive elements)
Options
Option | Value |
---|---|
Returns |
Set of topology.topoelement |
Language |
|
Parameters |
tg topology.topogeometry |
Definition
CREATE OR REPLACE FUNCTION topology.gettopogeomelements (
tg topology.topogeometry
)
RETURNS SETOF topology.topoelement AS
$span$
DECLARE
toponame varchar;
rec RECORD;
BEGIN
toponame = topology.GetTopologyName(tg.topology_id);
FOR rec IN SELECT * FROM topology.GetTopoGeomElements(toponame,
tg.layer_id,tg.id) as ret
LOOP
RETURN NEXT rec.ret;
END LOOP;
RETURN;
END;
$span$
LANGUAGE 'plpgsql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100 ROWS 1000;
COMMENT ON FUNCTION topology.gettopogeomelements(tg topology.topogeometry)
IS 'args: tg - Returns a set of topoelement objects containing the topological element_id,element_type of the given TopoGeometry (primitive elements)';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 13/03/2014 13:23 |