ST_Geometry ( geomtype, xcoord, ycoord, [, zcoord ] [, asrid ] )
Syntax Elements
- 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.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.
asrid is required if you also pass a zcoord argument.