- Categories:
ST_MAKEPOINT , ST_POINT¶
Constructs a GEOGRAPHY object that represents a point with the specified longitude and latitude.
- See also:
Syntax¶
ST_MAKEPOINT( <longitude> , <latitude> )
Arguments¶
longitude
A REAL that represents the longitude.
latitude
A REAL that represents the latitude.
Returns¶
The function returns a value of type GEOGRAPHY.
Usage notes¶
ST_POINT is an alias for ST_MAKEPOINT.
Examples¶
This shows a simple use of the ST_MAKEPOINT function:
SELECT ST_MAKEPOINT(37.5, 45.5); +--------------------------+ | ST_MAKEPOINT(37.5, 45.5) | |--------------------------| | POINT(37.5 45.5) | +--------------------------+