title: How to make bulk update with arrays in PostgreSQL?
body: <p>In <strong>PostgreSQL</strong> database I have table called <code>services</code> which has 4 columns. Is it possible to make a mass update via arrays? I tried such code but it raise error:</p>
  
  <pre><code>SQL Error [0A000]: ERROR: set-returning functions are not allowed in WHERE
  </code></pre>
  
  <p>SQL:</p>
  
  <pre><code>UPDATE SERVICES
  SET
      NAME = UNNEST(ARRAY['NAME OF THE FIRST SERVICE', 'NAME OF THE SECOND SERVICE']),
      ACTIVE = UNNEST(ARRAY[FALSE, TRUE]),
      DESCRIPTION = UNNEST(ARRAY['DESCRIPTION OF THE FIRST SERVICE', 'DESCRIPTION OF THE SECOND SERVICE'])
  WHERE
      ID = UNNEST(ARRAY['e1433cd2-7591-4a74-b910-33ea89d87ecd', '6c27c413-4be2-4a89-bea0-e713445ebfe1']);
  </code></pre>