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@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 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
