title: UPDATE ... LIMIT 1 PostgreSQL without PK
body: <p>Could you please help me creating SQL request for PostgreSQL for updating <strong>first</strong> record in a table without primary key?
  Something like </p>
  
  <pre><code>UPDATE "company"
  SET "salary" = 6
  WHERE "name" = 'x' AND "age" = 5 AND "address" = 'x' AND "salary" = 5
  LIMIT 1;  
  </code></pre>
  
  <p>*Please note table doesn't have PK. It means there can be absolutely same record with same values</p>