# MI_GeometryN

## Description

Returns the n^{th} 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 2^{nd} 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