Thread: per-statement, after, what's new?

per-statement, after, what's new?

From
Kenneth Downs
Date:
Hi folks,

I cannot find this in Google, Google groups, online docs, or the
archive, so I hope somebody can help me.

If I define a per-statement AFTER INSERT trigger, how are the new rows
exposed to the trigger?

Put another way, what is the equivalent to the row-level variables NEW
and OLD that exist in row-level triggers?

Thanks!



Attachment

Re: per-statement, after, what's new?

From
Tom Lane
Date:
Kenneth Downs <ken@secdat.com> writes:
> If I define a per-statement AFTER INSERT trigger, how are the new rows
> exposed to the trigger?

They aren't.

            regards, tom lane