ST_SRIDFromBaseType(VARCHAR(128)) method

Syntax

ST_Geometry::ST_SRIDFromBaseType(VARCHAR(128) base_type_str)

Parameters

• base_type_str – A string containing the base type string

Returns

INT Returns the SRID from a type string. If no SRID is specified by the string, returns NULL. If the type string is not a valid geometry type string, an error is returned.

Examples

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

  SELECT ST_Geometry::ST_SRIDFromBaseType('ST_Geometry')

  The following example returns the result 4326.

  SELECT ST_Geometry::ST_SRIDFromBaseType('ST_Geometry(SRID=4326)')

Standards

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