ST_SRIDFromBaseType method

ST_Geometry::ST_SRIDFromBaseType(base-type-str)

Name	Type	Description
base-type-str	VARCHAR(128)	A string containing the base type string

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.

The ST_Geometry::ST_SRIDFromBaseType method can be used to parse the SRID out of a type string definition.

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)')