On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær [email protected] [firebird-support]" <[email protected]> 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
