Daniel Roth <dan(dot)c(dot)roth(at)gmail(dot)com> writes:
> But MSSQL (SQL Server) does predicate locking.
> Places a range lock on the data set, preventing other users from
> updating or inserting rows into the data set until the transaction is
> complete. This is the most restrictive of the four isolation levels.
Range locks are a far cry from general predicate locks.
regards, tom lane
PS: kindly don't email me privately while posting the same message to
the lists. You think I have time to answer things twice?