Skip to main content
Returns the LineString geometry representing the maximum distance between any two points from the input geometries. ST_LongestLine

​
Signatures

ST_LongestLine(geom1: Geometry, geom2: Geometry)

​
Parameters

​
geom1
Geometry
required
The geom1 value.
​
geom2
Geometry
required
The geom2 value.

​
Return type

The resulting geometry.

​
Example

SELECT ST_LongestLine(
        ST_GeomFromText("POLYGON ((30 10, 40 40, 20 40, 10 20, 30 10))"),
        ST_GeomFromText("POLYGON ((10 20, 30 30, 40 20, 30 10, 10 20))")
)

LINESTRING (40 40, 10 20)