title: How to solve 'ERROR: operator does not exist: '?
body: <p>I have a table created like this:</p>
  
  <pre><code>CREATE TABLE revinfo
  (
     rev integer NOT NULL,
     revtstmp bigint,
     CONSTRAINT revinfo_pkey PRIMARY KEY (rev)
  )
  </code></pre>
  
  <p>Inside this table, I have data like this:</p>
  
  <pre><code>rev  |revtstmp 
  40815|1390021342972
  40816|1390021401403
  40817|1390021409057
  40818|1390021409914
  40819|1390021411074
  40821|1390021463885
  40822|1390021467889
  40824|1390021469035
  40826|1390021470065
  40827|1390021472134
  ...
  </code></pre>
  
  <p>I want to list all revisions made after the 10th of February 2015.
  I tried this request:</p>
  
  <pre><code>select rev
  from revinfo
  where revtstmp &gt; '2015-02-10 00:00:00'::timestamp
  </code></pre>
  
  <p>I hit this error:(see translation below)</p>
  
  <pre><code>ERREUR:  l'opérateur n'existe pas : bigint &gt; timestamp without time zone
  LINE 3: where revtstmp &gt; '2015-02-12 00:00:00'::timestamp
                         ^
  HINT:  Aucun opérateur ne correspond au nom donné et aux types d'arguments.
  Vous devez ajouter des conversions explicites de type.
  ********** Erreur **********
  
  ERREUR: l'opérateur n'existe pas : bigint &gt; timestamp without time zone
  État SQL :42883
  Astuce : Aucun opérateur ne correspond au nom donné et aux types d'arguments.
  Vous devez ajouter des conversions explicites de type.
  Caractère : 47
  </code></pre>
  
  <p>How can I change my query ?</p>
  
  <hr>
  
  <p><em>Translation (powered by Google Translate)</em></p>
  
  <pre><code>ERROR: operator does not exist: bigint&gt; timestamp without time zone
  LINE 3: where revtstmp&gt; '2015-02-12 0:00:00' :: timestamp
  ^
  HINT: No operator matches the given name and argument types.
  You must add explicit type conversions.
  ********** ********** Error
  
  ERROR: operator does not exist: bigint&gt; timestamp without time zone
  SQL State: 42883
  Tip: No operator matches the given name and argument types.
  You must add explicit type conversions.
  Character: 47
  </code></pre>