While it's good to have the two new examples, the confusion is in this section: http://orientdb.com/docs/master/SQL-Delete-Edge.html#deleting-edges-from-a-sub-query
Not the examples section. On Friday, August 26, 2016 at 1:18:27 PM UTC-4, l.garulli wrote: > > I've just updated the documentation with 2 more examples ;-) > > Best Regards, > > Luca Garulli > Founder & CEO > OrientDB LTD <http://orientdb.com/> > > Want to share your opinion about OrientDB? > Rate & review us at Gartner's Software Review > <https://www.gartner.com/reviews/survey/home> > > > On 26 August 2016 at 03:36, odbuser <[email protected] <javascript:>> > wrote: > >> I think the documentation is currently misleading but not wrong. >> >> When you know the rid of the edge, the simplest syntax is: >> DELETE EDGE #11:0 >> >> But the following two statements will also work: >> DELETE EDGE WHERE @rid IN (SELECT FROM #11:0) >> DELETE EDGE E WHERE @rid IN (SELECT FROM #11:0) >> >> And the following will not b/c it's the record reference in the FROM >> should be a vertex not an edge: >> DELETE EDGE FROM (SELECT FROM #11:0) >> Cannot retrieve a vertex with the RID #11:0 because it is an edge >> >> But the documentation on >> http://orientdb.com/docs/master/SQL-Delete-Edge.html >> <http://www.google.com/url?q=http%3A%2F%2Forientdb.com%2Fdocs%2Fmaster%2FSQL-Delete-Edge.html&sa=D&sntz=1&usg=AFQjCNF3Mc8LaosRTemLH3wZwujmk2V7zw> >> >> is referring to subqueries so the example may not be the best to illustrate >> the point. >> >> In any case, I suggest that you open an issue in the git documentation >> project: >> https://github.com/orientechnologies/orientdb-docs/issues >> and make sure you mention the version of OrientDB that you are using, >> reference the link to the documentation, what it says, and what you think >> it should say. >> >> >> >> >> >> >> On Friday, August 26, 2016 at 2:26:41 AM UTC-4, hartmut bischoff wrote: >>> >>> http://orientdb.com/docs/master/SQL-Delete-Edge.html >>> >>> Deleting Edges from a Sub-query >>> >>> Consider a situation where you have an edge with a Record ID of #11:0 >>> that you want to delete. In attempting to do so, you run the following >>> query: >>> >>> orientdb> DELETE EDGE FROM (SELECT FROM #11:0) >>> (...) >>> >>> >>> Syntax >>> >>> DELETE EDGE >>> ( <rid> >>> | >>> [<rid> (, <rid>)*] >>> (...) >>> >>> >>> If I want to delete the Edge #11:0, I run >>> DELETE EDGE #11:0 >>> >>> >>> The documentation tells me to use >>> DELETE EDGE E WHERE @rid IN (SELECT FROM #11:0) >>> instead >>> >>> >>> -- >> >> --- >> 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] <javascript:>. >> 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.
