Name
dist_from_point_to_line_segment — returns the distance between a point and a segment on a plane.
Synopsis
dist_from_point_to_line_segment
(
|
in Xpoint any , |
| in Ypoint any , | |
| in Xsegment1 any , | |
| in Ysegment1 any , | |
| in Xsegment2 any , | |
in
Ysegment2
any
); |
Description
returns the distance between a point and a segment on a plane.
Parameters
Xpoint
A X point
Ypoint
A Y point
Xsegment1
X Segment
Ysegment1
Y Segment
Xsegment2
X Segment
Ysegment2
Y Segment
Return Types
Returns any.
Examples
Example 24.657. Simple Use
SQL> select dist_from_point_to_line_segment (5, 5, 0, 3, 4, 0) 4.6 SQL> select dist_from_point_to_line_segment (5, 0, 0, 3, 4, 0) 1 SQL> select dist_from_point_to_line_segment (5, -1, 0, 3, 4, 0) 1.414213562373095 SQL> select dist_from_point_to_line_segment (5, -5, 0, 3, 4, 0) 5.099019513592784