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