Email: support@essaywriterpros.com
Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

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