title: How do i fetch NULL values in Postgreql and difference between NULL and NULL::Character varying?
body: <p>When I query the Postgres DB with <code>SELECT * FROM table2 WHERE empty IS NULL</code> I get nothing, and I get all the rows when I use <code>WHERE empty = ''</code>. </p>
  
  <p>It would seem then like Table Output will not convert your empties to nulls. Maybe you could convert nulls to empties exactly before the output.</p>
  
  <p>Example:</p>
  
  <pre><code>select * from "Attendance_SwipeEffHrs" where "TimsyHrs" is null. 
  </code></pre>
  
  <p>It shows 3 records. In other hand, if i use,  </p>
  
  <pre><code>select * from "Attendance_SwipeEffHrs" where "TimsyHrs"=''.
  </code></pre>
  
  <p>It Shows 5 records. I did not insert empty records in the field. So how can i get all the records. </p>