Skip to main content

ST_XMAX

Introduced or updated: v1.2.458

Returns the maximum longitude (X coordinate) of all points contained in the specified GEOMETRY object.

Syntax

ST_XMAX(<geometry>)

Arguments

ArgumentsDescription
<geometry>The argument must be an expression of type GEOMETRY.

Return Type

Double.

Examples

SELECT
ST_XMAX(
TO_GEOMETRY(
'GEOMETRYCOLLECTION(POINT(40 10),LINESTRING(10 10,20 20,10 40),POINT EMPTY)'
)
) AS pipeline_xmax;

┌───────────────┐
│ pipeline_xmax │
├───────────────┤
40
└───────────────┘

SELECT
ST_XMAX(
TO_GEOMETRY(
'GEOMETRYCOLLECTION(POINT(40 10),LINESTRING(10 10,20 20,10 40),POLYGON((40 40,20 45,45 30,40 40)))'
)
) AS pipeline_xmax;

┌───────────────┐
│ pipeline_xmax │
├───────────────┤
45
└───────────────┘
Explore Databend Cloud for FREE
Low-cost
Fast Analytics
Easy Data Ingestion
Elastic Scaling
Try it today