POINT_IN_ELLIPSES

Returns 1 if the point lies inside any of the provided ellipses, otherwise returns 0. Each ellipse is defined by a center point and its semi-major and semi-minor axes.

Syntax

POINT_IN_ELLIPSES(x, y, x1, y1, a1, b1 [, x2, y2, a2, b2, ...])

Arguments

Return Type

UInt8 (1 for true, 0 for false).

Examples

SELECT POINT_IN_ELLIPSES(10, 10, 10, 9.1, 1, 0.9999) AS inside;

╭────────╮
│ inside │
├────────┤
│      1 │
╰────────╯