Traditional comparisons
tcell {=, <>, <, >, <=, >=} tcell → boolean
SELECT th3index '831c02fffffffff@2001-01-01' = th3index '831c02fffffffff@2001-01-01'; -- t SELECT tquadbin '48a6227affffffff@2001-01-01' < tquadbin '485623ffffffffff@2001-01-01'; -- f SELECT ts2cell '47c3c@2001-01-01' = ts2cell '47c3c@2001-01-01'; -- t
Ever and always comparisons
{cell,tcell} {?=, ?<>, %=, %<>} {cell,tcell} → boolean
The probe operand may be a bare cell identifier or another tcell trajectory, in either operand position. The e-prefixed forms hold when the relationship holds at at least one instant, the a-prefixed forms when it holds across the entire time span.
SELECT th3index '[831c02fffffffff@2001-01-01, 880326b885fffff@2001-01-05]' ?= h3index '880326b885fffff'; -- t SELECT tquadbin '[48a6227affffffff@2001-01-01, 485623ffffffffff@2001-01-05]' %= quadbin '485623ffffffffff'; -- f SELECT ts2cell '47c3c@2001-01-01' ?= s2cell '47c3c'; -- t
Temporal comparisons
{cell,tcell} {#=, #<>} {cell,tcell} → tbool
Return a temporal boolean giving the per-instant equality, or inequality, between a temporal cell and a probe
SELECT th3index '831c02fffffffff@2001-01-01' #= h3index '831c02fffffffff'; -- t@2001-01-01 SELECT tquadbin '48a6227affffffff@2001-01-01' #<> quadbin '485623ffffffffff'; -- t@2001-01-01 SELECT ts2cell '47c3c@2001-01-01' #= s2cell '47c3c'; -- t@2001-01-01