Subject Re: [firebird-support] What is more effective execute block or select?
Author Mark Rotteveel
On Thu, 28 Jan 2016 16:22:03 +0100, "Svein Erling Tysvær
[firebird-support]" <> 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
> 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.