In postgres if I run the following statement
update table set col = 1 where col = 2
In the default READ COMMITTED isolation level, from multiple concurrent sessions, am I guaranteed that:
- In a case of a single match only 1 thread will get a ROWCOUNT of 1 (meaning only one thread writes)
- In a case of a multi match that only 1 thread will get a ROWCOUNT > 0 (meaning only one thread writes the batch)