LINESTRING()

This page is part of MariaDB's SkySQL Documentation.

The parent of this page is: Functions

Topics on this page:

Overview
EXAMPLES
CHANGE HISTORY
EXTERNAL REFERENCES

Overview

Constructs a WKB LineString value from a number of WKB Point arguments. If any argument is not a WKB Point, the return value is NULL. If the number of Point arguments is less than two, the return value is NULL.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

CREATE TABLE ls (c1 LINESTRING);

INSERT INTO ls VALUES
  (LineString(Point(0,0), Point(10,10), Point(20,20), Point(30,30)));

SELECT ST_AsText(c1) FROM ls;

+-----------------------------------+
| ST_AsText(c1)                     |
+-----------------------------------+
| LINESTRING(0 0,10 10,20 20,30 30) |
+-----------------------------------+

CHANGE HISTORY

Release Series	History
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES

Additional information on this topic may be found in the MariaDB Public Knowledge Base.

This page shows information specific to MariaDB SkySQL. Information for non-SkySQL use can be found on the LINESTRING() page in the MariaDB Enterprise Documentation.