RE: JSONB arrays

[Steven Winfield]

      From: Victor Noagbodji [mailto:vnoagbo...@amplify-nation.com]
      Sent: 28 June 2018 11:28
      To: pgsql-general
      Subject: JSONB arrays

      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


Try the @> operator:

select '[1, 2, 3, 4]'::jsonb @> '[4, 2]'::jsonb


Steve.