ST_WITHIN

Returns TRUE if the first GEOMETRY object is completely within the second GEOMETRY object.

Syntax

ST_WITHIN(<geometry1>, <geometry2>)

Arguments

Return Type

Boolean.

Examples

SELECT ST_WITHIN(
  TO_GEOMETRY('POINT(1 1)'),
  TO_GEOMETRY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))')
) AS within;

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