module pixeltable.functions.math
Pixeltable UDFs for mathematical operations.
Example:
udf abs()
Return the absolute value of the given number.
Equivalent to Python builtins.abs().
udf bitwise_and()
Bitwise AND of two integers.
Equivalent to Python
self & other.
udf bitwise_or()
Bitwise OR of two integers.
Equivalent to Python
self | other.
udf bitwise_xor()
Bitwise XOR of two integers.
Equivalent to Python
self ^ other.
udf ceil()
Return the ceiling of the given number.
Equivalent to Python float(math.ceil(self)) if self
is finite, or self itself if self is infinite. (This is slightly different from the default behavior of
math.ceil(self), which always returns an int and raises an error if self is infinite. The behavior in
Pixeltable generalizes the Python operator and is chosen to align with the SQL standard.)
udf floor()
Return the ceiling of the given number.
Equivalent to Python float(math.floor(self)) if self
is finite, or self itself if self is infinite. (This is slightly different from the default behavior of
math.floor(self), which always returns an int and raises an error if self is infinite. The behavior of
Pixeltable generalizes the Python operator and is chosen to align with the SQL standard.)
udf pow()
Raise self to the power of other.
Equivalent to Python self ** other.
udf round()
Round a number to a given precision in decimal digits.
Equivalent to Python builtins.round(self, digits or 0).
Note that if digits is not specified, the behavior matches builtins.round(self, 0) rather than
builtins.round(self); this ensures that the return type is always float (as in SQL) rather than int.Last modified on January 15, 2026
