ST_Point data type

The ST_Point data type is a zero-dimensional geometry that occupies a single location in coordinate space. ST_Point is used to define features such as oil wells, landmarks, and elevations.

Properties

An ST_Point has a single X,Y coordinate value, is always simple, and has a NULL boundary. An ST_Point may include a Z coordinate and an M value.

Functions

The following functions operate solely on the ST_Point data type:
ST_X()
The function returns a point data type's X coordinate value as a double-precision number.
ST_Y()
The function returns a point data type's Y coordinate value as a double-precision number.
SE_Z()
The function returns a point data type's Z coordinate value as a double-precision number.
SE_M()
The function returns a point data type's M coordinate value as a double-precision number.