ST_ZMin() method

Retrieves the minimum Z coordinate value of a geometry.

Syntax

geometry-expression.ST_ZMin()

DOUBLE Returns the minimum Z coordinate value of the geometry-expression.

Example 1 – The following example returns the result 3.

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

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