Blocking math [Obj,Int]
Description
Executes a free math expression on the values of the second column, for matching objects (according to the PAIRS input).
Warning: this block can fail if the expression is invalid (e.g., referring to a non available mathematical function), or if the expressions computes to invalid results (e.g., division by zero).
Input
A [OBJ,INTEGER]: a list of pairsPAIRS: Pairs ofA(first column) andB(second column) objects for which to compute the expressionB [OBJ,INTEGER]: a list of pairs
Output
RESA [OBJ,INTEGER]: result of the operation, with matching objects fromARESB [OBJ,INTEGER]: result of the operation, with matching objects fromB
Parameters
Expression: the mathematical expression to compute- use
$Aand$Bto refer to the values comings from inputsAandB - arithmetic operators and common mathematical functions can be used
- the expression is evaluated by the database engine. See MonetDB Functions and Operators for a full list of functions and operators available.
- use