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)'