POLYGON()
This page is part of MariaDB's Enterprise Documentation.
The parent of this page is: Functions
Topics on this page:
Overview
Constructs a WKB Polygon value from a number of WKB LineString arguments. If any argument does not represent the WKB of a LinearRing (that is, not a closed and simple LineString) the return value is NULL.
See also: Functions in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS
EXAMPLES
CREATE TABLE polygon (c1 POLYGON);
INSERT INTO polygon VALUES
(Polygon(LineString(Point(0,0), Point(1,1), Point(2,2), Point(0,0)),
LineString(Point(1,2), Point(2,3), Point(3,4), Point(1,2))));
SELECT ST_AsText(c1) FROM polygon;
+----------------------------------------------+
| ST_AsText(c1) |
+----------------------------------------------+
| POLYGON((0 0,1 1,2 2,0 0),(1 2,2 3,3 4,1 2)) |
+----------------------------------------------+
CHANGE HISTORY
Release Series | History |
---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.
Information specific to MariaDB SkySQL can be found on the POLYGON() page in the SkySQL Documentation.