'how to check if the array is empty and length

I have table like this, the e-id is a array,it can be empty, one or more elements, how can I filter the id which has zero, one or more elements of e-id? thank you so much!

enter image description here

sql


Solution 1:[1]

You could try to using the ARRAY_CONCAT function and check if the string is equal to ""

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Gerson Rodriguez