Extended Operators
Query columns with a bit set in both of two rows (repositories that are starred by both of two users):
Intersect(Row(stargazer=1), Row(stargazer=2))
{"attrs":{},"columns":[10]}
- columns are repositories that were starred by user 1 AND user 2
Difference
Spec:
Difference(<ROW_CALL>, [ROW_CALL ...])
Description:
Difference returns all of the bits from the first ROW_CALL
argument passed to it, without the bits from each subsequent ROW_CALL
.
Result Type: object with attrs and columns
attrs will always be empty
Examples:
Query columns with a bit set in one row and not another (repositories that are starred by one user and not another):
Difference(Row(stargazer=1), Row(stargazer=2))
{"results":[{"attrs":{},"columns":[20]}]}
- columns are repositories that were starred by user 1 BUT NOT user 2
Query for the opposite difference:
Difference(Row(stargazer=2), Row(stargazer=1))
{"attrs":{},"columns":[30]}
- columns are repositories that were starred by user 2 BUT NOT user