ST_Point returns a point geometry from the input coordinate values.
Syntax
ST_Point(x, y)
Arguments
- x
-
A value of data type
DOUBLE PRECISIONthat represents a first coordinate. - y
-
A value of data type
DOUBLE PRECISIONthat represents a second coordinate.
Return type
GEOMETRY of subtype POINT.
The spatial reference system identifier (SRID) value of the returned geometry is set to 0.
If x or y is null, then null is returned.
Examples
The following SQL constructs a point geometry from the input coordinates.
SELECT ST_AsText(ST_Point(5.0, 7.0));
st_astext
-------------
POINT(5 7)
