ST_POINT

Creates a GEOGRAPHY point from given x (longitude) and y (latitude) coordinates.

See also:

• ST_LINESTRING
• ST_POLYGON

Syntax

ST_POINT(<x>, <y>)

Arguments

• <x>: A FLOAT8 or FLOAT4 value representing the longitude
• <y>: A FLOAT8 or FLOAT4 value representing the latitude

Returns

Returns a GEOGRAPHY object of subtype ST_Point.

Example

SELECT ST_AsText(ST_POINT(1, 1));
-- 'POINT(1 1)'