Jeff Amiel <jamiel(at)istreamimaging(dot)com> writes:
>> "the docs say that in case of locked rows the where clause is reevaluated: "
> Is this true?
> Which docs are you refering to (I could find no mention in the postgres
> docs).....
Second paragraph in
http://developer.postgresql.org/docs/postgres/transaction-iso.html#XACT-READ-COMMITTED
regards, tom lane