ST_XMax method for type ST

geometry-expression.ST_XMax()

DOUBLE Returns the maximum X coordinate value of the geometry-expression.

Returns the maximum X coordinate value of the geometry-expression. This is computed by comparing the X attribute of all points in the geometry.

Note that in round-Earth model, minimum corresponds to eastern boundary of the geometry-expression and maximum corresponds to the western boundary of the geometry-expression. This means that if the geometry-expression crosses date line, minimum value will be higher than maximum value.

Note

If the geometry-expression is an empty geometry (ST_IsEmpty()=1), then this method returns NULL.

Note

By default, ST_XMax uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension

The following example returns the result 5.

SELECT NEW ST_LineString( 'LineString ZM( 1 2 3 4, 5 6 7 8 )' ).ST_XMax()

ST_XMax method for type ST_Geometry

Syntax

Returns

Remarks

Note

Note

See also

Standards and compatibility

Example