title: Condition on a timestamp column to select data for a year
body: <p>It's a simple <code>SELECT</code>, but the condition is only the year of a date. Ex.:</p>
  
  <pre><code>SELECT * FROM project WHERE project_reg = '2013';
  </code></pre>
  
  <p><code>project_reg</code> is type <code>timestamp</code>. The error returned is "syntax is not valid".</p>
  
  <blockquote>
    <p>ERROR:  la sintaxis de entrada no es válida para tipo timestamp: «2013»</p>
  </blockquote>