Name

ST_Point — Creates a Point given its coordinates. This is an Alias from ST_MakePoint

Synopsis

geometry ST_MakePoint(double precision X, double precision Y);

geometry ST_MakePoint(double precision X, double precision Y, double precision Z);

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

Alias

Point, ST_MakePoint, MakePoint

Description

Creates a Point given its coordinates. The point can be 2D (X,Y), 3D (X,Y,Z) or 4D (X,Y,Z,M) where M is a measure. This is an Alias from ST_MakePoint

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
---6.1.2

Examples

--Return the EWKT from a 4D point
SELECT ST_Asewkt(ST_Point(-3.668421,40.423813,510,48));

--Result
POINT (-3.668421 40.423813 510 48)

--Set the Srid for a Point
SELECT ST_Asewkt(ST_SetSrid(ST_Point(-3.668421,40.423813),4326));

--Result
SRID=4326;POINT (-3.668421 40.423813)

Related functions

ST_MakePoint , ST_PointFromText