ST_nearestApproachDistance-PolarDB(PolarDB)-阿里云帮助中心

Returns the nearest approach distance between two trajectory objects over a specified time range.

Syntax

float8 ST_nearestApproachDistance(trajectory traj, trajectory traj2);
float8 ST_nearestApproachDistance(trajectory traj, trajectory traj2, tsrange range);
float8 ST_nearestApproachDistance(trajectory traj, trajectory traj2, timestamp t1, timestamp t2);

Parameters

Parameter	Description
`traj`	The first trajectory object.
`traj2`	The second trajectory object.
`t1`	The start time of the time range.
`t2`	The end time of the time range.
`range`	The time range, specified as a `tsrange` value.

Examples

Select ST_nearestApproachDistance((Select traj from traj_table where id=1), (Select traj from traj_table where id=2), '2010-1-1 13:00:00', '2010-1-1 14:00:00');