title: How to delete first few records from a table without any criteria in PostgreSQL?
body: <p>I want to delete first 500 records from my table without any condition.</p>
  
  <p>Table definition is as follow:</p>
  
  <pre><code>CREATE TABLE txn_log
  (
    txn_log_timestamp timestamp without time zone NOT NULL,
    txn_log_pgm_id character(6)
  )
  WITH (OIDS=FALSE);
  </code></pre>
  
  <p>I don't have any primary key here. I tried to delete using</p>
  
  <pre><code>DELETE FROM txn_log LIMIT 500
  </code></pre>
  
  <p>but it throwing error:</p>
  
  <blockquote>
    <p>ERROR:  syntax error at or near "LIMIT" LINE 1: DELETE FROM TXN_LOG
    LIMIT 5000
                            ^</p>
    
    <p>********** Error **********</p>
    
    <p>ERROR: syntax error at or near "LIMIT"</p>
  </blockquote>
  
  <p>Can someone suggest me a way to do this?</p>