or

Syntax

or(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

select id, value from t where id=2 or id=3;

id	value
2	5
3	6

Related functions: and, not

.. meta::
:keywords: or