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

Function: _asgmlnode

Schema

topology

Owner

albenard

Descriptions

There is no description for function _asgmlnode

Options

Definition

CREATE OR REPLACE FUNCTION topology._asgmlnode (
 id integer,
 point public.geometry,
 nsprefix_in text,
 prec integer,
 options integer,
 idprefix text,
 gmlver integer
)
RETURNS text AS
$span$
DECLARE
 nsprefix text;
 gml text;
BEGIN

 nsprefix := 'gml:';
 IF NOT nsprefix_in IS NULL THEN
   IF nsprefix_in = '' THEN
     nsprefix = nsprefix_in;
   ELSE
     nsprefix = nsprefix_in || ':';
   END IF;
 END IF;

 gml := '<' || nsprefix || 'Node ' || nsprefix
   || 'id="' || idprefix || 'N' || id || '"';
 IF point IS NOT NULL THEN
   gml = gml || '>'
             || '<' || nsprefix || 'pointProperty>'
             || ST_AsGML(gmlver, point, prec, options, nsprefix_in)
             || '</' || nsprefix || 'pointProperty>'
             || '</' || nsprefix || 'Node>';
 ELSE
   gml = gml || '/>';
 END IF;
 RETURN gml;
END
$span$
LANGUAGE 'plpgsql'
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;

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