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

On Thu, Mar 05, 2020 at 08:58:32AM -0700, David G. Johnston wrote:
> On Thu, Mar 5, 2020 at 7:58 AM stan <stanb@panix.com> 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

Yes, I was thinking that might be what I had to do. My thinking right now
is to create a WHERE clause for the new statement, using (perhaps a subset)
of the columns returned by this.


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin