title: PostgreSQL - casting varchar to int?
body: <p>I'm trying to execute the following query:</p>
  
  <pre><code>DELETE FROM table_name WHERE ID&gt;9;
  </code></pre>
  
  <p>But i can't since the 'ID' field is of type 'varchar'.
  How can i cast it to 'int' and have it act properly? (deleting all rows with <code>ID</code> greater than 9 rather than converting it to a numeric <code>varchar</code> value)</p>