Re: A question about the number of times a trigger will fire

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Mar 5, 2020 at 7:58 AM stan <stanb@xxxxxxxxx> wrote:

UPDATE BOM_ITEM SET  cost_per_unit = 23.45 , qty = 12345.00

So, it appears that I need to create a WHERE clause for the resultant
statement. But I do not see how the function has enough data to use to
create this where clause.

What am I missing, here?

OLD and/or NEW?

https://www.postgresql.org/docs/12/plpgsql-trigger.html#PLPGSQL-DML-TRIGGER

David J.