ST_XMIN
Introduced or updated: v1.2.512
Returns the minimum longitude (X coordinate) of all points contained in the specified GEOMETRY object.
Syntax
ST_XMIN(<geometry>)
Arguments
Arguments | Description |
---|---|
<geometry> | The argument must be an expression of type GEOMETRY. |
Return Type
Double.
Examples
SELECT
ST_XMIN(
TO_GEOMETRY(
'GEOMETRYCOLLECTION(POINT(180 10),LINESTRING(20 10,30 20,40 40),POINT EMPTY)'
)
) AS pipeline_xmin;
┌───────────────┐
│ pipeline_xmin │
├───────────────┤
│ 20 │
└───────────────┘
SELECT
ST_XMIN(
TO_GEOMETRY(
'GEOMETRYCOLLECTION(POINT(40 10),LINESTRING(20 10,30 20,10 40),POLYGON((40 40,20 45,45 30,40 40)))'
)
) AS pipeline_xmin;
┌───────────────┐
│ pipeline_xmin │
├───────────────┤