GET_Y¶

The GET_Y function returns the y-coordinate of a given POINT data type. It takes one POINT data type argument and returns a FLOAT value representing the y-coordinate.

Syntax¶

GET_Y(point)

Parameters:

• point: The geographical coordinate of type Point from which the Y-coordinate will be extracted.

Examples¶

Consider the following table PointGroup:

CREATE TABLE PointGroup (
    point_field POINT
);

With the following data:

INSERT INTO PointGroup VALUES (POINT(0.3134, 0.156));

Example 1: Get the Y-coordinate from a point¶

SELECT GET_Y(point_field) AS point_field FROM PointGroup;

Result:

Example 2: Get the Y-coordinate from a point using CAST¶

SELECT GET_Y(CAST('POINT(0.1 -0.2)' AS POINT)) AS ptx;

Result:

Example 3: Get the Y-coordinate from a point using POINT function¶

SELECT GET_Y(POINT(0.1, -0.2)) AS ptx;

Result:

Errors¶

If the argument is not of type Point, a FunctionRequiresPointValue error will be thrown.