Subject Re: [Firebird-Architect] REPLACE, again
Author Adriano dos Santos Fernandes
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.