title: How to use properly the PostgreSQL operator ?| to select data from a table conains a column with a text[]
body: <p>In my table Documents I have to retrieve the document ID where I have the recipientIds</p>
  <p>The PSQL I was trying but with error <code>operator does not exist: text[] ?| unknown</code></p>
  <pre><code>select
      *
  from
      documents d
  where
      recipients::text[] ?| array['qfxKzhSc5tsaZ4ko6AxMb',
      'Y9RKXWGXnD2J_5bxyfNRN']::text[]
  </code></pre>
  <p>The table document looks as this</p>
  <p><a href="https://i.stack.imgur.com/E8Gqr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/E8Gqr.png" alt="Document table" /></a></p>
  <p>As you see the recipients column is where I have the issue as that data type is</p>
  <pre><code>'{}'::text[]
  </code></pre>
  <p>My result should that given an array of recipientIds like <code>['qfxKzhSc5tsaZ4ko6AxMb','Y9RKXWGXnD2J_5bxyfNRN']</code>
  I'm selecting the corresponding documents.id.</p>
  <p>I tried to us the <code>@&gt;</code> but this contains operator match only what we have in the array but not if I put two different recipientIds as like above in my example.</p>
  <p>I need to use the <code>OR</code> operator and I thought this <code>?|</code> will do the trick but I have error and don't know the proper way of doing this</p>