Schema
Owner
postgres
Descriptions
args: toponame - Returns the SRID of a topology in the topology.topology table given the name of the topology.
Options
Option | Value |
---|---|
Returns |
integer |
Language |
|
Parameters |
toponame varchar |
Definition
CREATE OR REPLACE FUNCTION topology.gettopologyid (
toponame varchar
)
RETURNS integer AS
$span$
DECLARE
ret integer;
BEGIN
SELECT id INTO ret
FROM topology.topology WHERE name = toponame;
IF NOT FOUND THEN
RAISE EXCEPTION 'Topology % does not exist', quote_literal(toponame);
END IF;
RETURN ret;
END
$span$
LANGUAGE 'plpgsql'
STABLE
RETURNS NULL ON NULL INPUT
SECURITY INVOKER
COST 100;
COMMENT ON FUNCTION topology.gettopologyid(toponame varchar)
IS 'args: toponame - Returns the SRID of a topology in the topology.topology table given the name of the topology.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23 |