Cypher: Match nodes that share the exact same relationships

[benjamintre (Ben Tremain)]

Hi,

I'm stuck on the following problem...

I have a simple graph with Person and Product nodes, and BOUGHT relationships.

I need a cypher query that will return pairs (or lists) of Person nodes that bought exactly the same products.

So for instance, on the left below, Person A and Person B satisfy the condition, whereas in the example on the right they do not (because Person B hasn't bought Product 1.

I hope this makes sense, I don't really have any idea where to start so any pointers will be greatly appreciated!

Thanks

[benjamintre (Ben Tremain)]

wonderful answer, thank you @glilienfield !

[glilienfield (Gary Lilienfield)]

If the a pair of persons purchased exactly the same products, that means the number of products they purchased the same must equal the number of products each of them purchased individually. The query below derives pairs of people using this approach:

match(p1:Person)-[:BOUGHT]->(:Product)<-[:BOUGHT]-(p2:Person) 
where id(p1)<id(p2)
with p1, p2, count(*) as numOfProducts
where size((p1)-[:BOUGHT]->(:Product)) = numOfProducts 
and size((p2)-[:BOUGHT]->(:Product)) = numOfProducts
return p1.name as name1, p2.name as name2