Hi,
there is someone working in add the MERGE statement?
i don't find much about what a good implementation of merge must have...
i think what it needs to do is something like:
- try to lock the rows for update - if the lock cannot be immediatly acquire ask why - if the rows are already
locked,wait and try again? - if no rows were found try de insert part - if there was any other error, abort -
elseupdate
so i suppose we can reuse many of the code breaking the merge in 3
pieces... for now they are just thougths, i will think more in this
and try to implement it...
comments? ideas? suggestions?
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)