ST_Polygon( ST_Point , ST_Point ) constructor

Creates an axis-aligned rectangle from two points representing the lower-left and upper-right corners.

Syntax

NEW ST_Polygon( ST_Point pmin, ST_Point pmax)

Parameters

pmin – A point that is the lower-left corner of the rectangle.
pmax – A point that is the upper-right corner of the rectangle.

Returns

ST_Polygon Returns an axis-aligned rectangle.

Examples

Example 1 – The following returns Polygon ((0 0, 4 0, 4 10, 0 10, 0 0)).
```
SELECT NEW ST_Polygon(NEW ST_Point(0.0, 0.0), NEW ST_Point(4.0, 10.0))
```

Standards

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

Parent topic: ST_Polygon type

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