UPDATE <class> REMOVE ... from embedded list by index?

58 views
Skip to first unread message

Luke Worth

unread,
May 7, 2015, 4:45:29 AM5/7/15
to orient-...@googlegroups.com, luke....@tkbt.com
Hello,

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?

e.g. 

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

Reply all
Reply to author
Forward
0 new messages