Returns the nth point in the circularstring.
SELECT TREAT( Shape AS ST_CircularString ).ST_PointN( 3 ) FROM SpatialShapes WHERE ShapeID = 18
The following example returns one row for each point in geom.
BEGIN DECLARE geom ST_CircularString; SET geom = NEW ST_CircularString( 'CircularString( 0 0, 1 1, 2 0 )' ); SELECT row_num, geom.ST_PointN( row_num ) FROM sa_rowgenerator( 1, geom.ST_NumPoints() ) ORDER BY row_num; END
row_num | geom.ST_PointN(row_num) |
---|---|
1 | Point (0 0) |
2 | Point (1 1) |
3 | Point (2 0) |
SQL/MM (ISO/IEC 13249-3: 2006) 7.3.5