ARRAY_EXCEPT

Introduced or updated: v1.2.762

Returns a new JSON array containing the elements from the first JSON array that are not present in the second JSON array.

Aliases

• JSON_ARRAY_EXCEPT

Syntax

ARRAY_EXCEPT(<source_array>, <array_of_elements_to_exclude>)

Return Type

JSON array.

Examples

SELECT ARRAY_EXCEPT(
    '["apple", "banana", "orange"]'::VARIANT,  
    '["banana", "grapes"]'::VARIANT         
);

-[ RECORD 1 ]-----------------------------------
array_except('["apple", "banana", "orange"]'::VARIANT, '["banana", "grapes"]'::VARIANT): ["apple","orange"]

-- Return an empty array because all elements in the first array are present in the second array.
SELECT ARRAY_EXCEPT('["apple", "banana", "orange"]'::VARIANT, '["apple", "banana", "orange"]'::VARIANT)

-[ RECORD 1 ]-----------------------------------
array_except('["apple", "banana", "orange"]'::VARIANT, '["apple", "banana", "orange"]'::VARIANT): []