title: Select from literal values not in table in PostgreSQL?
body: <p>I have some values in Excel, I copy the values and it look like this:</p>
  
  <p>1
  2
  3
  4</p>
  
  <p>I want to write a query that select from above data that is not present in a table. Somethink like:</p>
  
  <pre><code>SELECT * FROM [1, 2, 3, 4] as foo where foo IS NOT ( SELECT id from table )
  </code></pre>
  
  <p>Supposing id column have 1,2,4 the query answer will be 3.</p>
  
  <p>Preferably a query that can work in postgres and sql server</p>
  
  <p>Thank you! </p>