title: LIMIT Postgres DELETE
body: <p>Simple DELETE with safety LIMIT throws a syntax error:</p>
  
  <pre><code>DELETE FROM system."products" LIMIT 1
  </code></pre>
  
  <blockquote>
    <p>ERROR: Syntax ERROR at "LIMIT"</p>
    
    <p>SQL state: 42601</p>
  </blockquote>
  
  <p>How do I limit the amount of rows to delete?</p>
  
  <p>(PostgresSQL version 9.6)</p>