ST_Point(DOUBLE, DOUBLE[, INT]) constructor

Constructs a 2D point from X,Y coordinates.

Syntax

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

Parameters

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

Returns

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

Examples

Example 1 – The following returns Point (10 20).
```
SELECT NEW ST_Point(10.0,20.0,0)
```

Standards

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

Parent topic: ST_Point type

Created December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com