title: ActiveRecord Query on text field PostgreSQL
body: <p>I have a table Products and around 58000 records in it. I run two queries are as follows.</p>
  
  <pre><code>Product.where(description: 'swiss').count
  </code></pre>
  
  <p>It returns <strong>0</strong> products out of <strong>58000</strong> products. But when I run query below.</p>
  
  <pre><code>Product.where.not(description: 'swiss').count
  </code></pre>
  
  <p>it returns <strong>2932</strong> products out of <strong>58000</strong> products. I think it should return all <strong>58000</strong> products, because it is the reverse of first query. 
  I did not understand why it returns only <strong>2932</strong> products.</p>