Categories:

Geospatial functions

ST_MAKEGEOMPOINT , ST_GEOMPOINT¶

Constructs a GEOMETRY object that represents a Point with the specified longitude and latitude.

See also:

TO_GEOMETRY

Syntax¶

ST_MAKEGEOMPOINT( <longitude> , <latitude> )
Copy

Arguments¶

longitude

A REAL that represents the longitude.

latitude

A REAL that represents the latitude.

Returns¶

The function returns a value of type GEOMETRY.

Usage notes¶

  • ST_GEOMPOINT is an alias for ST_MAKEGEOMPOINT.

Examples¶

For examples, see Examples comparing the GEOGRAPHY and GEOMETRY data types. The examples use the ST_GEOMPOINT alias.