Operators

More details can be found in MobilityDB’s documentation itself: https://docs.mobilitydb.com/nightly/index.html

class mobilitydb_sqlalchemy.comparator.Comparator(expr)

Bases: sqlalchemy.sql.type_api.Comparator

A custom comparator base class. It adds the ability to call spatial and temporal functions on columns that use this kind of comparator. It also defines functions that map to operators supported by TBool, TInt, TFloat and TGeomPoint columns.

always_different_from(other)

The “@<>” operator.

always_equal_to(other)

The “%=” operator.

Is lhs always equal to the rhs?

The function does not take into account whether the bounds are inclusive or not.

always_greater_than(other)

The “%>” operator.

always_greater_than_or_equal_to(other)

The “%>=” operator.

always_less_than(other)

The “%<” operator.

always_less_than_or_equal_to(other)

The “%<=” operator.

bbox_always_after(other)

The “<<#” operator.

bbox_always_before(other)

The “<<#” operator.

bbox_always_strictly_greater_than(other)

The “>>” operator.

bbox_always_strictly_less_than(other)

The “<<” operator.

bbox_contained(other)

The “<@” operator.

bbox_contains(other)

The “@>” operator.

bbox_does_not_extend_above(other)

The “|&>” operator.

bbox_does_not_extend_below(other)

The “&<|” operator.

bbox_does_not_extend_in_back(other)

The “/&>” operator.

bbox_does_not_extend_in_front(other)

The “&</” operator.

bbox_does_not_extend_to_left(other)

The “&>” operator.

bbox_does_not_extend_to_right(other)

The “&<” operator.

bbox_never_after(other)

The “&<#” operator.

bbox_never_before(other)

The “#&>” operator.

bbox_never_greater_than(other)

The “&<” operator.

bbox_never_less_than(other)

The “&>” operator.

bbox_strictly_above(other)

The “|>>” operator.

bbox_strictly_below(other)

The “<<|” operator.

bbox_strictly_in_back(other)

The “/>>” operator.

bbox_strictly_in_front(other)

The “<</” operator.

bbox_strictly_to_left(other)

The “<<” operator.

bbox_strictly_to_right(other)

The “>>” operator.

bboxes_equal(other)

The “~=” operator.

bboxes_overlap(other)

The “&&” operator.

distance(other)

The “<->” operator.

ever_different_from(other)

The “?<>” operator.

ever_equal_to(other)

The “?=” operator.

Is lhs ever equal to the rhs?

The function does not take into account whether the bounds are inclusive or not.

ever_greater_than(other)

The “?>” operator.

ever_greater_than_or_equal_to(other)

The “?>=” operator.

ever_less_than(other)

The “?<” operator.

ever_less_than_or_equal_to(other)

The “?<=” operator.

expr

smallest_distance_ever_between(other)

The “|=|” operator.

temporal_equal(other)

The “#=” operator.

temporal_greater_than(other)

The “#>” operator.

temporal_greater_than_or_equal_to(other)

The “#>=” operator.

temporal_less_than(other)

The “#<” operator.

temporal_less_than_or_equal_to(other)

The “#<=” operator.

temporal_not_equal(other)

The “#<>” operator.

type