title: postgresql: any on subquery returning array
body: <p>I have a user_lists table that contains a user_list column of type integer[].</p>
  
  <p>I'm trying to do this query, which seems basic enough:</p>
  
  <p><code>select id, alias from users where id = ANY(select user_list from user_lists where id = 2 limit 1);</code></p>
  
  <p>It gives this error:</p>
  
  <p>ERROR:  operator does not exist: integer = integer[]<br>
  HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.</p>
  
  <p>I'm using postgres 8.3.11. Upgrading is not an option.</p>
  
  <p>What am I missing?</p>