ST_MaxX, ST_MaxY, ST_MaxZ, ST_MaxM

Syntax

ST_MaxX(geo);
ST_MaxY(geo);
ST_MaxZ(geo);
ST_MaxM(geo);

geo

The input geometry.

Type: ST_GEOMETRY(ANY)

Returns

A value of type DOUBLE that is the maximum coordinate of all the elements of the input geometry, or NULL if input geometry is empty.

Examples

SELECT inza..ST_MaxM(inza..ST_WKTToSQL('POLYGON ZM((10 10 0 50, 10 20 1 60, 20 20 2 70, 20 15 3 80, 10 10 0 50))'));
 
ST_MAXM
-------
80
(1 row)

SELECT inza..ST_MaxX(inza..ST_WKTToSQL('POLYGON ((10 10, 10 20, 20 20, 20 15, 10 10))'));
 
ST_MAXX
---------
20
(1 row)

SELECT inza..ST_MaxX(inza..ST_WKTToSQL('MULTIPOINT(10 10, 30 15, 15 15, 20 20)'));
 
ST_MAXX
---------
30
(1 row)

SELECT inza..ST_MaxY(inza..ST_WKTToSQL('POLYGON ((10 10, 10 30, 20 20, 20 15, 10 10))'));
 
ST_MAXY
---------
30
(1 row)

SELECT inza..ST_MaxY(inza..ST_WKTToSQL('MULTIPOINT(10 10, 30 15, 15 15, 20 20)'));
 
ST_MAXY
---------
20
(1 row)

SELECT inza..ST_MaxZ(inza..ST_WKTToSQL('POLYGON Z((10 10 0, 10 20 1, 20 20 2, 20 15 3, 10 10 0))'));

ST_MAXZ
---------
3
(1 row)


SELECT inza..ST_MaxZ(inza..ST_WKTToSQL('POLYGON ZM((10 10 10 10, 10 20 20 20, 20 20 20 20, 20 15 15 40, 10 10 10 10))'));

ST_MAXZ
---------
20
(1 row)


SELECT inza..ST_MaxZ(inza..ST_WKTToSQL('LINESTRING EMPTY'));

ST_MAXZ
---------
(1 row)