or
Syntax
(X, Y) or X||Y
Arguments
X or Y is a
scalar/pair/vector/matrix. If X or Y is a pair/vector/matrix, the other is
a scalar or a pair/vector/matrix of the same size.
Details
This function returns the element-by-element logical X OR Y.
Note:
If the operands of or or || contain NULL values, the
operator || returns NULL, while the function or returns different
results for different server versions:
-
For versions earlier than 1.30.21.4/2.00.9.4, or returns NULL.
-
For version 1.30.21.4/2.00.9.4 or higher, the result may differ based on the configuration parameter logicOrIgnoreNull.
| Operand A | Operand B | result (when logicOrIgnoreNull= true) | result (when logicOrIgnoreNull= false) |
|---|---|---|---|
| non-zero | NULL | true | NULL |
| zero | NULL | false | NULL |
| NULL | NULL | NULL | NULL |
Examples
$ >1 || 0;
1
$ x=1 0 1;
$ x || 0;
[1,0,1]
$ y=0 1 0;
$ x or y;
[1,1,1]
$ t=table(1..3 as id, 4..6 as value);
$ t; | id | value |
|---|---|
| 1 | 4 |
| 2 | 5 |
| 3 | 6 |
.. code:: sql
select id, value from t where id=2 or id=3; | id | value |
|---|---|
| 2 | 5 |
| 3 | 6 |