ST_BUFFER()

Overview

Returns a geometry representing the points that are at the specified distance from the specified geometry.

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

SELECT SUBSTRING(ST_AsWKT(ST_BUFFER(Point(5, 5), 1)), 1, 72) AS `Buffer substring`;
+--------------------------------------------------------------------------+
| Buffer substring                                                         |
+--------------------------------------------------------------------------+
| POLYGON((5 4,4.950932325672582 4.001204543794827,4.901982859670439 4.004 |
+--------------------------------------------------------------------------+
SET @point = ST_GeomFromText('POINT(1 1)');
SELECT ST_AsText(ST_Buffer(@point, 0));
+---------------------------------+
| ST_AsText(ST_Buffer(@point, 0)) |
+---------------------------------+
| POINT(1 1)                      |
+---------------------------------+
SET @point = ST_GeomFromText('POINT(1 1)');
SELECT ST_AsText(ST_Buffer(@point, -1));
+----------------------------------+
| ST_AsText(ST_Buffer(@point, -1)) |
+----------------------------------+
| GEOMETRYCOLLECTION EMPTY         |
+----------------------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES