ST_3DDistance

Return the 3-dimensional minimum cartesian distance between A and B

Signatures

ST_3DDistance (A: Geometry, B: Geometry)

Geometry

required

The input geometry.

Geometry

required

The second geometry.

A numeric value.

SELECT ST_3DDistance(ST_GeomFromText("POINT Z (0 0 -5)"),
                     ST_GeomFromText("POINT Z(1  1 -6"))

1.7320508075688772

⌘I