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)