Returns the nth curve in the compound curve.
By default, ST_CurveN uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.
compoundcurve-expression.ST_CurveN(n)
Name | Type | Description |
---|---|---|
n |
INT |
The position of the element to return, from 1 to compoundcurve-expression.ST_NumCurves(). |
ST_Curve Returns the nth curve in the compound curve.
The spatial reference system identifier of the result is the same as the spatial reference system of the compoundcurve-expression.
SQL/MM (ISO/IEC 13249-3: 2006) 7.4.5
The following example returns the result CircularString (0 0, 1 1, 2 0)
.
SELECT TREAT( Shape AS ST_CompoundCurve ).ST_CurveN( 1 ) FROM SpatialShapes WHERE ShapeID = 17 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |