and

Syntax

and(X, Y)

or

X && Y

Arguments

X / 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

Return the element-by-element logical X AND Y.

Examples

1 && 3;
// output
1

x=1 2 3
x && 0
// output
[0,0,0]

x=1 2 3
y=0 1 0
x && y
// output
[0,1,0]

t=table(1 2 2 3 as id, 4 5 6 5 as value)
t
id value
1 4
2 5
2 6
3 5
select id, value from t where id=2 and value=5;
id value
2 5

Related functions: or, not