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);