st_disjoint function

Applies to: Databricks SQL Databricks Runtime 17.1 and above

Returns true if the two input GEOMETRY values are disjoint.

Syntax

st_disjoint ( geoExpr1, geoExpr2 )

Arguments

• geoExpr1: The first GEOMETRY value.
• geoExpr2: The second GEOMETRY value.

Returns

A value of type BOOLEAN, indicating whether the two input GEOMETRY values are disjoint.

For more details and the formal definition, see the Disjoint predicate in the DE-9IM matrix definition.

The function returns NULL if any of the inputs is NULL.

Error conditions

• If the two input geometries have different SRID values, the function returns ST_DIFFERENT_SRID_VALUES.

Examples

-- Returns false if geometries are not disjoint.
> SELECT st_disjoint(st_geomfromtext('POINT(1 1)'),st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'));
  false
-- Returns true if geometries are disjoint.
> SELECT st_disjoint(st_geomfromtext('POINT(5 6)'),st_geomfromtext('POLYGON((0 0,10 0,0 10,0 0))'));
  true

Related functions

• st_contains function
• st_covers function
• st_equals function
• st_intersects function
• st_touches function
• st_within function