Returns an ST_Geometry value that represents a 2D or 3D ST_Point.
|
Argument … |
Specifies … |
|
geomtype |
a VARCHAR(80) for the type of spatial object to create. The geomtype argument must be set to 'ST_POINT'. |
|
xcoord |
a FLOAT value for the x coordinate of the point. The value should be entered in floating point format. |
|
ycoord |
a FLOAT value for the y coordinate of the point. The value should be entered in floating point format. |
|
zcoord |
a FLOAT value for the z coordinate of the point, if the point is represented in 3D space. The value should be entered in floating point format. Note: If you specify a zcoord, you must also specify an asrid. |
|
asrid |
an optional INTEGER value for the spatial reference system identifier. If this argument is omitted, the spatial reference system identifier is set to 0. Note: asrid is required if you also pass a zcoord argument. |
Use this constructor to construct an ST_Geometry that represents a 2D or 3D ST_Point.
INSERT INTO sample_shapes
VALUES (1101, NEW ST_Geometry('ST_POINT', 1E1, 2E1));
SELECT NEW ST_Geometry('ST_Point', 10.0, 20.0);
SELECT NEW ST_Geometry('ST_Point', 10.0, 20.0, 1699);
SELECT NEW ST_Geometry('ST_Point', 10.0, 20.0, 5.0, 1699);