title: Firebird 2.5 update or insert into
body: <p>I can't figure out how to write a SQL statement in Firebird so it should add new row, and if some conditions meet to update also other column.</p>
  
  <p>Example:</p>
  
  <p>(in MySql looks like this:)</p>
  
  <pre><code>insert into 
  table (col1, col2, col3) values ('a', 'b', 'c')
  on duplicate key update col4=col3;
  </code></pre>