opencypher.org | opencypher@googlegroups.com opencypher.org | opencypher@googlegroups.com DO opencypher.org | opencypher@googlegroups.com UNION INTERSECT opencypher.org | opencypher@googlegroups.com
SLIDE 1
pencypher.org | opencypher@googlegroups.com
pencypher.org | opencypher@googlegroups.com
SLIDE 2
pencypher.org | opencypher@googlegroups.com
DO
SLIDE 3
pencypher.org | opencypher@googlegroups.com
UNION
INTERSECT
SLIDE 4
pencypher.org | opencypher@googlegroups.com
EXCLUSIVE UNION
EXCLUDE
SLIDE 5
pencypher.org | opencypher@googlegroups.com
MATCH (a:Person)-[:LIVES_IN]->(:City {name: "Berlin"}) RETURN * INTERSECT MATCH (a:Person)-[:BORN_IN]->(:City {name: "London"}) RETURN *
SLIDE 6
pencypher.org | opencypher@googlegroups.com
MATCH (a:Person)-[:LIVES_IN]->(:City {name: "Berlin"}) RETURN * INTERSECT { MATCH (a:Person)-[:BORN_IN]->(:City {name: "London"}) RETURN * UNION MATCH (a:Person)-[:BORN_IN]->(:City {name: "New York City"}) RETURN * }
SLIDE 7
pencypher.org | opencypher@googlegroups.com
MATCH (a:Person)-[:BORN_IN]->(:City {name: "London"}) RETURN * UNION MATCH (a:Person)-[:BORN_IN]->(:City {name: "New York City"}) RETURN * INTERSECT MATCH (a:Person)-[:LIVES_IN]->(:City {name: "Berlin"}) RETURN *
MATCH (city:City) RETURN city CROSS MATCH (continent:Continent) RETURN continent THEN RETURN city.name, continent.name, EXISTS { (city)-[:PARTNER]-(other:City)-[:IN]->(continent) }
SLIDE 14
pencypher.org | opencypher@googlegroups.com
MATCH (p:Person)-[:LIVES_IN]->(c:City) RETURN * LIMIT 1 OTHERWISE MATCH (a:Person)-[:WORKS_IN]->(c:City) RETURN * LIMIT 1 THEN MATCH (c)-[:RECOMMEND]->(attraction:Attraction) RETURN p.name, attraction.name, attraction.price
