On Thu, Mar 5, 2020 at 7:58 AM stan <stanb(at)panix(dot)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
David J.