JSONB arrays

[Victor Noagbodji <vnoagbodji@xxxxxxxxxxxxxxxxxx>]

Hey people,

I ended up with the following to check (or similar to return) the intersection of two list of values on a JSONB object:

array_length(
array(
select jsonb_array_elements_text(col1)
intersect
select jsonb_array_elements_text(col2)
), 1) > 0

Is there a better way?

Thanks