On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær
setysvar@...
[firebird-support]" <firebird-support@yahoogroups.com> wrote:

> No, I must admit limited knowledge of MERGE. For Firebird 3 is seems

like a

> good alternative, but I think Fb 2.1 and 2.5(?) requires a WHEN NOT

MATCHED

> THEN INSERT clause (which is typically not desirable in these cases).

I don't have a Firebird install available right now, but looking at the
syntax file (parse.y), the WHEN NOT MATCHED THEN INSERT clause is not
required, not in 2.1 nor in 2.5. The syntax in the language reference
suggests it is required, but as far as I can see it isn't.

Mark