Product DocumentationAppearance
ST_CROSSES
Returns TRUE if two GEOGRAPHY objects have intersecting interiors but do not share all interior points. The intersection must have a dimension less than the maximum dimension of the input GEOGRAPHY objects.
This function is symmetric, meaning:
ST_CROSSES(a, b)=ST_CROSSES(b, a)
See also:
Syntax
sql
ST_CROSSES(<a>, <b>)Arguments
<a>and<b>: The twoGEOGRAPHYobjects to compare
Returns
Returns a BOOLEAN:
TRUEif theGEOGRAPHYobjects crossFALSEif they do not cross, or in cases involving Point/Point or Area/Area comparisons
Behavior
| Input Types | Result |
|---|---|
| Point/Line | TRUE if the point lies on the line's interior |
| Point/Area | TRUE if the point lies within the area's interior |
| Line/Line | TRUE if the lines intersect at one or more points |
| Line/Area | TRUE if the line intersects the area's interior |
| Area/Area | Always FALSE |
| Point/Point | Always FALSE |