title: UPDATE order in PostgreSQL
body: <p>I have a mysql command:</p>
  
  <pre><code> update table_demo SET flag= 1 where flag=0 ORDER BY id ASC LIMIT 10
  </code></pre>
  
  <p>and need the same command in Postgres, I get this error:  </p>
  
  <blockquote>
    <p>ERROR: syntax error at or near <code>'ORDER'</code></p>
  </blockquote>