Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

ST_MMax - Amazon Redshift

ST_MMax

ST_MMax returns the maximum m coordinate of an input geometry.

Syntax

ST_MMax(geom)

Arguments

geom

A value of data type GEOMETRY or an expression that evaluates to a GEOMETRY type.

Return type

DOUBLE PRECISION value of the maximum m coordinate.

If geom is empty, then null is returned.

If geom is null, then null is returned.

If geom is a 2D or 3DZ geometry, then null is returned.

Examples

The following SQL returns the largest m coordinate of a linestring in a 3DM geometry.

SELECT ST_MMax(ST_GeomFromEWKT('LINESTRING M (0 1 2, 3 4 5, 6 7 8)'));
st_mmax ----------- 8

The following SQL returns the largest m coordinate of a linestring in a 4D geometry.

SELECT ST_MMax(ST_GeomFromEWKT('LINESTRING ZM (0 1 2 3, 4 5 6 7, 8 9 10 11)'));
st_mmax ----------- 11
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.