ST_Point

Create a point geometry with specific coordinates.

Syntax

ST_Point(x, y[, {z|m}[, isZ]][, srid]);
ST_Point(x, y, z, m[, srid]);
x
The x coordinate.

Type: DOUBLE

y
The y coordinate.

Type: DOUBLE

z
The z coordinate.

Type: DOUBLE

m
The m (measurement) coordinate.

Type: DOUBLE

isZ
Whether the third parameter is a z coordinate (if TRUE) or m coordinate (if FALSE).

Type: BOOL

Default: TRUE

srid
The Spatial reference system identifier.

Type: INT4

Returns

A value of type ST_GEOMETRY(126) that contains a point geometry.

Examples

SELECT inza..ST_AsText(inza..ST_Point(1.0, 5.0)); 

ST_ASTEXT
-----------
POINT (1 5)
(1 row)

SELECT inza..ST_AsText(inza..ST_Point(1.0, 5.0, 6.0)); 

ST_ASTEXT
-----------
POINT Z (1 5 6)
(1 row)
 
SELECT inza..ST_AsText(inza..ST_Point(1.0, 5.0, 8.0, False, 4326));
 
ST_ASTEXT
-----------
POINT M (1 5 8)
(1 row)