Returns the specified point from an ST_Geometry type that represents an ST_LineString or GeoSequence value.
|
Argument … |
Specifies … |
|
aposition |
an INTEGER value for the requested point, where the position of the first point is 1. |
Returns an ST_Geometry value.
ST_LineString and GeoSequence
This method returns a point having a z coordinate if the input geometry is 3-dimensional.
SELECT shape.ST_PointN(2)
FROM sample_shapes
WHERE skey = 9902;