--- On Tue, 1/1/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Please provide a self-contained example.
Basically the example demonstrates the difference a single tuple UPDATE when preformed the following two ways:
UPDATE table ...; -- Sees OLD.
BEGIN; UPDATE table ...; COMMIT; --Sees NEW.
I was my understanding that all single DML statement are wrapped in their own transaction so I thought that these two
statementsshould preform the same.
Regards,
Richard Broersma Jr.