Jaime Casanova wrote:
>>Funny, we were just discussing this at OpenDBCon. Seems that you can't do a
>>full implementation of MERGE without Predicate Locking (the ability to say
>>"lock this table against inserts or updates of any row with key=5").
>>
>>
>
>it isn't what select for update does?
>
>
>
>
>
It won't prevent the insertion of a row with the given predicate.
cheers
andrew