ST_Geometry::ST_GeometryTypeFromBaseType(base-type-str)

The ST_Geometry::ST_GeometryTypeFromBaseType method can be used to parse the geometry type name out of a type string definition.

• ST_SRIDFromBaseType method for type ST_Geometry

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'