On Mon, 15 Sept 2025 at 17:32, Chao Li <[email protected]> wrote: > UPDATE, DELETE, SELECT FOR UPDATE, and SELECT FOR SHARE commands behave the > same as SELECT in terms of searching for target rows: they will only find > target rows that were committed as of the command start time. > > It says that UPDATE will only find target rows that were committed as of the > command start time. I think the statement implies that an “update” statement > will never update a “future” tuple.
I think you've only read the first sentence in that paragraph. Please read the entire paragraph. You'll see it goes on to explain "it will attempt to apply its operation to the updated version of the row". David
