Hi Eric, The UPDATE SET syntax is allowed also in v 2.2.x, but the || operator is a new addition and won't be backported to 2.2
Thanks Luigi 2018-01-20 17:34 GMT+01:00 Eric24 <[email protected]>: > Thanks Luigi; makes perfect sense. Is this syntax also supported on 2.2.x? > > On Tuesday, January 2, 2018 at 2:23:32 AM UTC-6, Luigi Dell'Aquila wrote: >> >> Hi Eric, >> >> The alternatives are: >> >> >> PUT: just use dot notation >> >> UPDATE ADoc PUT aMap = "aKey", "aValue" >> >> can be written as >> >> UPDATE ADoc SET aMap.aKey = "aValue" >> or >> UPDATE ADoc SET aMap["aKey"] = "aValue" >> >> >> ADD: use array concatenation || >> >> UPDATE ADoc PUT aList = "aValue" >> >> can be written as >> >> UPDATE ADoc SET aList = aList || "aValue" >> or >> UPDATE ADoc SET aList = "aValue" || aList >> depending on where you want to add the value (first or last element of >> the list). For sets it does not make any difference of course >> >> For a full reference see http://orientdb.com/docs/3 >> .0.x/sql/SQL-Syntax.html >> >> Thanks >> >> Luigi >> >> >> 2018-01-02 7:32 GMT+01:00 <[email protected]>: >> >>> Hi, >>> >>> you can take a look at these links: >>> >>> *OrientDB 3.0 Release Notes: *https://github.com/orie >>> ntechnologies/orientdb/wiki/OrientDB-3.0-Release-Notes >>> >>> *OrientDB 2.2 Release Notes: *https://github.com/orie >>> ntechnologies/orientdb/wiki/OrientDB-2.2-Release-Notes >>> >>> Here you can see all the differences / enhancement. >>> >>> Hope it helps >>> >>> Regards, >>> >>> Michela >>> >>> -- >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OrientDB" 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. >>> >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" 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. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" 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.
