"Nando Dessena" <nando@...> wrote:

>
> I'm not sure I understand you. Is your point that the standard syntax
> makes it difficult/cumbersome/impossible to implement with a
> parameterized statement?

For me, the standard syntax is too heavy/complex in 80% of cases (single
table and matching via equality). Writing complete form of update and insert
statements plus search condition looks quite redundant. But this is just a
personal opinion.

> It seems to me that REPLACE is to MERGE what COALESCE (and NULLIF) is
> to CASE: a special case common enough to justify a shortcut notation.
> Is that correct?

Absolutely.


Dmitry