per-statement, after, what's new?

Started by Kenneth Downsabout 20 years ago2 messagesgeneral
Jump to latest
#1Kenneth Downs
ken@secdat.com

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!

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Kenneth Downs (#1)
Re: per-statement, after, what's new?

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