ST_BoundingDiagonal

Updated at:

Returns the diagonal of a bounding box for a given geometry object.

Syntax

geometry ST_BoundingDiagonal(meshgeom geom, boolean fits default false);
geometry ST_BoundingDiagonal(sfmesh sfmeshObject, boolean fits default false);

Parameters

ParameterDescription
geomThe meshgeom object.
sfmeshObjectThe sfmesh object.
fitsSpecifies whether accurate calculation is required. Default value: false.

Description

ST_BoundingDiagonal computes the diagonal of an object's bounding box and returns it as a geometry value.

Examples

select ST_AsText(ST_BoundingDiagonal('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))'::meshgeom));

Output:

LINESTRING Z (0 0 1,10 10 3)