Name

ST_MakePointM — Creates a Point given its x,y,m coordinates.

Synopsis

geometry ST_MakePointM(double precision X, double precision Y, double precision Z, double precision M);

Alias

MakePointM

Description

Creates a Point given its coordinates. The point's coordinates obtained will be formatted as XYZM with Z=0.

The OGC function is ST_PointFromText.

Coordinate Dimensions
2D3DM
-
Spatial Standards Support
OGC SFS for SQL. 1.1 (1999)OGC SFS for SQL. 1.1.0 (2005)OGC SFS for SQL. 1.2.0 (2006)SQL-MM Part 3
----

Examples

--Returns the EWKT Representation of a point.
SELECT ST_Asewkt(ST_MakePointM(-3.668421,40.423813,48));

--Result
POINT (-3.668421 40.423813 0 48)

Related functions

ST_MakePoint, ST_PointFromText