title: PostgreSQL 'NOT IN' and subquery
body: <p>I'm trying to execute this query:</p>
  
  <pre><code>SELECT mac, creation_date 
  FROM logs 
  WHERE logs_type_id=11
  AND mac NOT IN (select consols.mac from consols)
  </code></pre>
  
  <p>But I get no results. I tested it, and I know that there is something wrong with the syntax. In MySQL such a query works perfectly. I've added a row to be sure that there is one <code>mac</code> which does not exist in the <code>consols</code> table, but still it isn't giving any results.</p>