title: Postgres - How to check for an empty array
body: <p>I'm using Postgres and I'm trying to write a query like this:</p>
  
  <pre><code>select count(*) from table where datasets = ARRAY[]
  </code></pre>
  
  <p>i.e. I want to know how many rows have an empty array for a certain column, but postgres doesn't like that:</p>
  
  <pre><code>select count(*) from super_eds where datasets = ARRAY[];
  ERROR:  syntax error at or near "]"
  LINE 1: select count(*) from super_eds where datasets = ARRAY[];
                                                               ^
  </code></pre>