ST_GeometryTypeFromBaseType(VARCHAR(128)) method

Syntax

ST_Geometry::ST_GeometryTypeFromBaseType(VARCHAR(128) base_type_str)

Parameters

• base_type_str – A string containing the base type string

Returns

VARCHAR_0123128321_ Returns the geometry type from a base type string (which may include a SRID definition). If the type string is not a valid geometry type string, an error is returned.

Examples

• Example 1 – The following example returns the result ST_Geometry.

  SELECT ST_Geometry::ST_GeometryTypeFromBaseType('ST_Geometry')

  The following example returns the result ST_Point.

  SELECT ST_Geometry::ST_GeometryTypeFromBaseType('ST_Point(SRID=4326)')

  The following example finds the geometry type (ST_Point) accepted by a stored procedure parameter.

  CREATE PROCEDURE myprocedure( parm1 ST_Point(SRID=0) )
  BEGIN
  -- ...
  END;SELECT	parm_name nm, base_type_str, ST_Geometry::ST_GeometryTypeFromBaseType(base_type_str) geom_type
  FROM	sysprocedure KEY JOIN sysprocparm
  WHERE	proc_name='myprocedure' and parm_name='parm1'

Standards

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension