ST_Distance

Introduction: Return the Euclidean distance between A and B

Format: ST_Distance (A: Geometry, B: Geometry)

Return type: Double

Since: v1.2.0

Example:

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

Output:

31.155515639003543