Howto update duplicates in firebird?

Question

Hi everyone.

Searched google for "firebird update duplicates" and "firebird handle duplicate update" but did not get any stuff, that would solve my question; so i thought it would be a good idea to use this marvellous site for the first time :) So how do i achieve mysql's "INSERT INTO asdf (x,y,z) VALUES ('a',1,2) ON DUPLICATE KEYS UPDATE z = 2" in firebird?

thanks in advance!

Answer 1

UPDATE OR INSERT INTO <table or view> [(<column_list>)]
    VALUES (<value_list>)
    [MATCHING (<column_list>)]
    [RETURNING <column_list> [INTO <variable_list>]]

Update or Insert