Johannes, youre absolutely right, and i agree! however, the import script i used did not take into account the fact that i may sometimes get arrays, and now my db has arrays and strings intermixed as the name property type.
so, to rectify it, i would like to grab all nodes which have name as an array, grab the first element (in ruby), then set the value of the property to that first element. On Thursday, January 2, 2014 4:17:33 PM UTC-6, Johannes Mockenhaupt wrote: > > I don't think having the same property be a string on some nodes and an > array on others is the way to go - you'll end up checking for type all > the time. Which is also not possible in Cypher as far as I know. Why not > make it an array/collection all the time and query it like this: > > MATCH (n:Superclass) > WHERE any(name IN n.name WHERE name =~ '(?i).*SWEATERS.*') > RETURN n > > On 01/02/2014 11:02 PM, Javad Karabi wrote: > > Johannes, that seems to be exactly it. some of my nodes have a string, > > some an array of strings. > > thank you > > > > is it possible, then, to test on a properties type? > > > > > > On Thursday, January 2, 2014 3:53:20 PM UTC-6, Johannes Mockenhaupt > wrote: > > > > I can reproduce this when the property in question is an array of > > strings. Thus your 'name' property appears to be an array where you > > expect it to be a string. > > > > On 01/02/2014 09:46 PM, Javad Karabi wrote: > > > match (n:Superclass) where n.name <http://n.name> =~ > > "(?i).*SWEATERS.*" return n; > > > > > > Expected [Ljava.lang.String;@36b3041f to be a java.lang.String, > > but it was a [Ljava.lang.String; > > > > > > Neo.ClientError.Statement.InvalidType > > > > > > did i do something wrong in the query? > > > > > > -- > > > 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/groups/opt_out > > <https://groups.google.com/groups/opt_out>. > > > > -- > > 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/groups/opt_out. > > -- 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/groups/opt_out.
