ST_Point(DOUBLE, DOUBLE, DOUBLE[, INT]) constructor

Syntax

NEW ST_Point(DOUBLE x, DOUBLE y, DOUBLE z[, INT srid])

Parameters

• x – The X coordinate value.
• y – The Y coordinate value.
• z – The Z coordinate value.
• srid – The SRID of the result. If not specified, the default is 0.

Returns

ST_Point Returns a 3D point with the specified X,Y,Z coordinates.

Examples

• Example 1 – The following returns Point Z (10 20 100).

  SELECT NEW ST_Point(10.0,20.0,100.0,0)

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 6.1.2