MI_GeometryN

Description

Returns the nth geometry in a MultiGeometry.

Syntax

geometry MI_GeometryN ( geometry, n )

Argument

geometry is an expression that returns a geometry.

n is the position of the geometry to be returned from the MultiGeometry.

Example

Returns the 2nd polygon listed for the specified Rhode Island state.

select MI_GeometryN([Geometry_Column], 2) as MI_GeometryN from "/USA" where state in ('RI')

Remarks

This function also enables the geometry disaggregation. If the input geometry is not a MultiGeometry (MultiPoint, MultiCurve, and MultiPolygon), and asking for the first geometry, the input geometry will be return. Otherwise null is returned