Interactions.sql File Reference

The implementantion in sql of SegmentSP. More...

Functions
void	intersection (segmentsp segment, boxsp box, boolean solid=true, integer n, segmentsp s, pointsp p)
	This function takes a spatial segment and a spatial box as parameters and returns the intersection of the segment with the box. There is also a third optional parameter, called “solid”, that when is set to false the function returns NULL when the segment is fully contained within the box without touching the perimeter. More...
void	intersection (segmentsp segmenta, segmentsp segmentb, integer n, segmentsp s, pointsp p)
	This function takes two spatial segments as parameters and returns the intersection of the segments. More...
pointsp	closestpoint (segmentsp segment, pointsp point)
	This function takes as input a segment and a point and returns the closest point of the segment. More...
void	closestpoints (segmentsp segmenta, segmentsp segmentb, boolean areequal, pointsp cpa, pointsp cpb)

Detailed Description

The implementantion in sql of SegmentSP.

Author

Marios Vodas (mvoda.nosp@m.s@gm.nosp@m.ail.c.nosp@m.om).

SegmentSP is a spatial data type used in Hermes

See also

Spatial data types

Function Documentation

pointsp closestpoint	(	segmentsp	segment,
		pointsp	point
	)

This function takes as input a segment and a point and returns the closest point of the segment.

Parameters

[in]	segment	the segment
[in]	point	the point

Returns

the closest point of the segment.

void closestpoints	(	segmentsp	segmenta,
		segmentsp	segmentb,
		boolean	areequal,
		pointsp	cpa,
		pointsp	cpb
	)

void intersection	(	segmentsp	segment,
		boxsp	box,
		boolean	solid = true,
		integer	n,
		segmentsp	s,
		pointsp	p
	)

This function takes a spatial segment and a spatial box as parameters and returns the intersection of the segment with the box. There is also a third optional parameter, called “solid”, that when is set to false the function returns NULL when the segment is fully contained within the box without touching the perimeter.

Parameters

[in]	segment	the segment
[in]	box	the box
[in]	solid	solid parameter of the function

Returns

the intersection of the segment with the box.

See also

Intersection

void intersection	(	segmentsp	segmenta,
		segmentsp	segmentb,
		integer	n,
		segmentsp	s,
		pointsp	p
	)

This function takes two spatial segments as parameters and returns the intersection of the segments.

Parameters

[in]	segmentA	the first segment
[in]	segmentB	the second segment

Returns

the intersection of the two segments.

See also

Intersection