ST_Distance

Return the Euclidean distance between A and B

Signatures

ST_Distance (A: Geometry, B: Geometry)

Geometry

required

The input geometry.

Geometry

required

The second geometry.

A numeric value.

SELECT ST_Distance(ST_GeomFromText('POINT(72 42)'), ST_GeomFromText('LINESTRING(-72 -42, 82 92)'))

31.155515639003543

⌘I