you are right: http://docs.neo4j.org/chunked/snapshot/cypher-cookbook.html#_basic_friend_finding_based_on_social_neighborhood states START joe=node:node_auto_index(name = "Joe") MATCH joe-[:knows]->friend-[:knows]->friend_of_friend, joe-[r?:knows]->friend_of_friend WHERE r IS NULL
Am 29.11.2011 13:14, schrieb D. Frej: > you might be right. I only used it the other way around (rel2 IS NOT > NULL) to guarante that the relationship is there. So I thought ... ;) > However, currently I am quite busy and cannot check easily. > > That brings me to a feature request for neoclipse: The possibility to > type and execute a cypher query. This would make answering this question > easy. > > > > Am 29.11.2011 13:04, schrieb Michael Hunger: >> Shouldn't rel2 then be an optional relationship? Otherwise IMHO it can never >> be null. >> >> >>> START c=... >>> MATCH c-[rel1:MyRel]->a, c-[rel2?:MyRel]->b >>> WHERE rel2 is null >>> RETURN c >> Am 29.11.2011 um 13:00 schrieb D. Frej: >> >>> I would recommend the following >>> >>> START c=... >>> MATCH c-[rel1:MyRel]->a, c-[rel2:MyRel]->b >>> WHERE rel2 is null >>> RETURN c >>> >>> even though it seems it little strange >>> >>> >>> >>> Am 29.11.2011 03:03, schrieb KanTube: >>>> while not ideal you could do >>>> >>>> START >>>> a=node:node_auto_index(NodeType="A"),b=node:node_auto_index(NodeType="B") >>>> MATCH a-[:MyRel]->c<-[r?:MyRel]-b >>>> RETURN c, count(r) >>>> >>>> and in your code you could filter for count(r) = 0 >>>> >>>> >>>> >>>> -- >>>> View this message in context: >>>> http://neo4j-community-discussions.438527.n3.nabble.com/cypher-question-subqueries-possible-tp3543685p3544033.html >>>> Sent from the Neo4j Community Discussions mailing list archive at >>>> Nabble.com. >>>> _______________________________________________ >>>> Neo4j mailing list >>>> User@lists.neo4j.org >>>> https://lists.neo4j.org/mailman/listinfo/user >>>> >>> _______________________________________________ >>> Neo4j mailing list >>> User@lists.neo4j.org >>> https://lists.neo4j.org/mailman/listinfo/user >> _______________________________________________ >> Neo4j mailing list >> User@lists.neo4j.org >> https://lists.neo4j.org/mailman/listinfo/user >> > _______________________________________________ > Neo4j mailing list > User@lists.neo4j.org > https://lists.neo4j.org/mailman/listinfo/user > _______________________________________________ Neo4j mailing list User@lists.neo4j.org https://lists.neo4j.org/mailman/listinfo/user
