ST_DISJOINT

Introduced or updated: v1.2.564

Returns TRUE if two GEOMETRY objects do not intersect.

Syntax

ST_DISJOINT(<geometry1>, <geometry2>)

Arguments

Arguments	Description
<geometry1>	The argument must be an expression of type GEOMETRY.
<geometry2>	The argument must be an expression of type GEOMETRY.

note

• The function reports an error if the two input GEOMETRY objects have different SRIDs.

Return Type

Boolean.

Examples

SELECT ST_DISJOINT(
  TO_GEOMETRY('POINT(3 3)'),
  TO_GEOMETRY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))')
) AS disjoint;

╭──────────╮
│ disjoint │
├──────────┤
│ true     │
╰──────────╯

SELECT ST_DISJOINT(
  TO_GEOMETRY('LINESTRING(0 0, 2 2)'),
  TO_GEOMETRY('LINESTRING(0 2, 2 0)')
) AS disjoint;

╭──────────╮
│ disjoint │
├──────────┤
│ false    │
╰──────────╯