I'm using OrientDB 2.0.8.
The SQL UPDATE command provides a REMOVE which lets me delete from embedded maps by Key, and other embedded collections by Value. Is there a way in the SQL to remove from an embedded list by element index?
update a set data = [1,2,3,4,5] -- data now contains [1,2,3,4,5]
update a remove data = 2 -- data now contains [1,3,4,5]
update a remove data[2] -- I wanted data to now contain [1,3,5], but this doesn't work