Leyne, Sean wrote:

> I thought the problem that REPLACE was intended to solve, is where you
> want to insert a new record but if it already exists, to update the
> existing row. As such, the insert must be performed before the update.
>

If you insert first, the statement will be dependent on PK/unique.
MATCHING causes the user to control what he wants to update or insert.


Adriano