Returns the nth point in the circular string.
By default, ST_PointN 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.
Syntaxcircularstring-expression.ST_PointN(n) Parameters| Name | Type | Description |
|---|---|---|
|
n |
INT |
The position of the element to return, from 1 to circularstring-expression.ST_NumPoints(). |
ReturnsST_Point If the linestring value is the empty set, returns NULL. If the specified position n is less than 1 or greater than the number of points, raises a warning and returns NULL. Otherwise, returns the ST_Point value at position n.
The spatial reference system identifier of the result is the same as the spatial reference system of the circularstring-expression.
Standards and compatibilitySQL/MM (ISO/IEC 13249-3: 2006) 7.3.5
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |