and(&&)
Syntax
X && Y
Arguments
X and 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;
1
$ x=1 2 3;
$ x && 0;
[0,0,0]
$ x=1 2 3;
$ y=0 1 0;
$ x && y;
[0,1,0]
$ m1=1 1 1 0 0 0$2:3;
$ m1;
#0 |
#1 |
#2 |
|---|---|---|
1 |
1 |
0 |
1 |
0 |
0 |
$ m1 && 0;
#0 |
#1 |
#2 |
|---|---|---|
0 |
0 |
0 |
0 |
0 |
0 |
$ m2=1 0 1 0 1 0$2:3;
$ m2;
#0 |
#1 |
#2 |
|---|---|---|
1 |
1 |
1 |
0 |
0 |
0 |
$ and(m1, m2);
#0 |
#1 |
#2 |
|---|---|---|
1 |
1 |
0 |
0 |
0 |
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; // SQL query
id |
value |
|---|---|
2 |
5 |