Re: Old/New

"Bob Pawley" <rjpawley(at)shaw(dot)ca> writes:
> I haven't found any documentation on how the underlying structure of
> PostgreSQL actually operates. So I have had to extrapolate.

> I think what you are saying is that on an update of a field the whole row
> which includes that field is affected to the extent that the whole row falls
> under the rules of New/Old.

In triggers, NEW and OLD are just rowtype variables that contain the
entire new and old versions of whatever row the ON UPDATE trigger was
fired for. You do not have to look into the table to find out anything
else about the update event, and doing so is generally a bad idea
because it'll be much slower than just looking at NEW/OLD.

You might be confusing this with the use of NEW/OLD in rules, where they
have a rather different meaning.

regards, tom lane