Thanks! I was thinking adding unique property and then create index/constraint might improve performance, would that be the case?
On Wednesday, March 23, 2016 at 3:53:31 PM UTC+8, Michael Hunger wrote: > > MATCH (p:Product)-[r:inside]->(c:Category) > > SET r.type = p.id + '->' + c.id > > But I *strongly recommend against* setting this kind of property !! > > As you can always compute the information! > > MATCH (p:Product)-[r:inside]->(c:Category) > > RETURN p.id + '->' + c.id > > > MERGE always tries to find the WHOLE pattern and if it can't find it will > CREATE it. > > Am 23.03.2016 um 08:36 schrieb kincheong lau <[email protected] > <javascript:>>: > > for each existing 'product' that 'inside' a 'category', I would like to > add a property in relationship 'product->category'. When I run below > cypher, it create a new relationship instead of adding new property in the > existing one...how can I make it 1 relationship only? > > > 1) Existing relationship before change > > (p:Product)-[r:inside]->(c.Category) > > there is no property in [ r ] > > 2) Cypher to run > > MATCH (p:Product), (c:Category) > MERGE (p)-[r:inside {type: p.id + '->' + c.id }]->(c) > > 3) it creates new relationship and the existing no change > > (p:Product)-[r:inside {type: p.id->c.id }]->(c:Category) > > (p:Product)-[r:inside]->(c:Category) > > > > > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
