Skip to main content
Skip to main content
Edit this page

maxIntersections

Aggregate function that calculates the maximum number of times that a group of intervals intersects each other (if all the intervals intersect at least once).

The syntax is:

Arguments

  • start_column – the numeric column that represents the start of each interval. If start_column is NULL or 0 then the interval will be skipped.

  • end_column - the numeric column that represents the end of each interval. If end_column is NULL or 0 then the interval will be skipped.

Returned value

Returns the maximum number of intersected intervals.

Example

The intervals look like the following:

Three of these intervals have a common value (the value is 4, but the value that is common is not important, we are measuring the count of the intersections). The intervals (1,3) and (3,7) share an endpoint but are not considered intersecting by the maxIntersections function.

Response:

If you have multiple occurrences of the maximum interval, you can use the maxIntersectionsPosition function to locate the number and location of those occurrences.