15.10 - ST_Y - Teradata Database

Teradata Database SQL Geospatial Types

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

Get and set the Y coordinate of an ST_Point value.

 

Argument …

Specifies …

ycoord

a FLOAT value for the new Y coordinate of the ST_Point value.

 

IF you pass in …

THEN ST_Y returns …

no argument

a FLOAT value for the Ycoordinate.

the ycoord argument

an ST_Geometry value where the Y coordinate is set to ycoord.

NULL

NULL

ST_Point

   SELECT skey1
   FROM sample_points1
   WHERE (point1.ST_Y() < 1E-2);