15.10 - ST_PointN - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

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;