ST_YMin method

geometry-expression.ST_YMin()

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

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

Note that for geographic spatial reference systems, the returned value corresponds to the first coordinate in the axis order. If the axis order is lon/lat/z/m, the minimum value corresponds to southernmost point of geometry-expression as returned by ST_LatSouth and the maximum value corresponds to the northernmost point of geometry-expression as returned by ST_LatNorth. If the axis order is lat/lon/a/m, the minimum value corresponds to the western boundary of geometry-expression as returned by ST_LongWest and the maximum value corresponds to the eastern boundary of the geometry-expression as returned by ST_LongEast. In round-Earth model, this means that if geometry-expression crosses the date line, the minimum value will be greater than the maximum value.

Note

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

Note

By default, ST_YMin 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 2.

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

ST_YMin method

Syntax

Returns

Remarks

Note

Note

See also

Standards and compatibility

Example