Logical negation: not
Syntax
not op
Input parameters
op |
the first operand |
Examples of valid syntaxes
not DS_1
Semantics for scalar operations
The not operator returns TRUE if op is FALSE, otherwise TRUE. The input operand must be of boolean type.
For example:
| not FALSE gives TRUE
| not TRUE gives FALSE
| not NULL gives NULL
Input parameters type
op
dataset {measure<boolean> _ }
| component<boolean>
| boolean
Result type
result
dataset {measure<boolean> _ }
| component<boolean>
| boolean
Additional Constraints
None.
Behaviour
The operator has the typical behaviour of the “Behaviour of Boolean operators” (see the section “Typical behaviours of the ML Operators”).
Examples
Given the operand dataset DS_1:
Input DS_1 (see structure)
Id_1 |
Id_2 |
Id_3 |
Id_4 |
Me_1 |
|---|---|---|---|---|
M |
15 |
B |
2013 |
True |
M |
64 |
B |
2013 |
False |
M |
65 |
B |
2013 |
True |
F |
15 |
U |
2013 |
False |
F |
64 |
U |
2013 |
False |
F |
65 |
U |
2013 |
True |
Example 1
DS_r:= not DS_1;
results in (see structure):
Id_1 |
Id_2 |
Id_3 |
Id_4 |
Me_1 |
|---|---|---|---|---|
M |
15 |
B |
2013 |
False |
M |
64 |
B |
2013 |
True |
M |
65 |
B |
2013 |
False |
F |
15 |
U |
2013 |
True |
F |
64 |
U |
2013 |
True |
F |
65 |
U |
2013 |
False |
Example 2
DS_r:= DS_1 [ calc Me_2 := not Me_1 ];
results in (see structure):
Id_1 |
Id_2 |
Id_3 |
Id_4 |
Me_1 |
Me_2 |
|---|---|---|---|---|---|
M |
15 |
B |
2013 |
True |
False |
M |
64 |
B |
2013 |
False |
True |
M |
65 |
B |
2013 |
True |
False |
F |
15 |
U |
2013 |
False |
True |
F |
64 |
U |
2013 |
False |
True |
F |
65 |
U |
2013 |
True |
False |