Jaime Casanova wrote:
> REPLACE will delete old records to insert new ones; MERGE try to
> insert and if the record exists then can UPDATE just a few values,
> maybe incrementing them with a value (all the calculation are doing
> by the MERGE)
I'm not the expert on REPLACE, but it would seem that REPLACE is a
special case of MERGE.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/