ST_GeometryN(INT) method

Syntax

geomcollection-expression.ST_GeometryN(INT n)

Parameters

• n – The position of the element to return, from 1 to geomcollection-expression.ST_NumGeometries().

Returns

ST_Geometry Returns the nth geometry in the geometry collection.

Examples

• Example 1 – The following example returns the result Polygon ((10 -5, 15 5, 5 5, 10 -5)).

  SELECT NEW ST_GeomCollection('GeometryCollection (CircularString (5 10, 10 12, 15 10), Polygon ((10 -5, 15 5, 5 5, 10 -5)))')
  .ST_GeometryN( 2 )

Standards

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