This SQL element is a shortcut for the User Defined Method SQL element with the User Defined Type field set to ST_GEOMCOLLECTION. Selecting this element will display a listing of methods for the ST_GEOMCOLLECTION type, described in the following table.
| Method | Definition |
|---|---|
| ST_GeometryN | Returns the geometry of one component member of a composite geometry type (ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, or ST_MultiPolygon). The element to be returned is specified by position with the collection. |
| ST_NumGeometries | Returns the number of distinct geometries that constitute a composite geometry type (ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, or ST_MultiPolygon). |
This feature requires Teradata 13.00 or later.