2 ms·
Weak example to ask precisely when the plane is at X feet, not an inch higher/lower - this is more typically a range query, and the Postgres range datatype is q
by asah 7y ago
Weak example to ask precisely when the plane is at X feet, not an inch higher/lower - this is more typically a range query, and the Postgres range datatype is quite good at this, notably GiST indexes for overlap queries:
https://www.postgresql.org/docs/9.3/functions-range.html#RANGE-OPERATORS-TABLE https://www.postgresql.org/docs/9.3/functions-range.html#RAN...
https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-INDEXING https://www.postgresql.org/docs/current/rangetypes.html#RANG...