[ASTERIXDB-2658] Add support for ARRAY_EXCEPT() function

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.4.1
• Fix Version/s: 0.9.5
• Component/s: FUN - Functions
• Assignee: Hussain Towaileb
• Reporter: Hussain Towaileb
• Created: 14/Oct/19 20:21
• Updated: 11/Nov/19 06:15
• Resolved: 11/Nov/19 06:15

Description

array_except takes 2 arguments, both arguments being arrays, and returns all the items in the first array minus the items in the second array.

 

Example:

array_except([1, 2, 3, 4], [2, 3]) -> [1, 4]
array_except([1, "2", "3"], ["2", 3]) -> [1, "3"]