MI_PointN

Description

Returns a point that is the nth vertex in the geometry.

Syntax

MI_PointN(geometry,n)

Arguments

geometry is an expression that returns a geometry.

nis the nth vertex in the geometry

Example

Returns the third point in the second polygon in the Rhode Island state of the USA.

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

Remarks

If the input is not a valid geometry, null is returned.