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/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster