Postgres Pro
Downloads
Home   >   mailing lists

Re: A question about the number of times a trigger will fire - Mailing list pgsql-general

From David G. Johnston
Subject Re: A question about the number of times a trigger will fire
Date
Msg-id CAKFQuwZA0ZEx7OehZ-26btGSwWxNmqeFUMc8Sz_PAAHUM1VM5A@mail.gmail.com
Whole thread Raw
In response to A question about the number of times a trigger will fire  (stan <stanb@panix.com>)
Responses Re: A question about the number of times a trigger will fire  (stan <stanb@panix.com>)
List pgsql-general
Tree view
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

David J.

pgsql-general by date:

Previous
From: David Gauthier
Date:
Subject: format return of "age" to hh:mm
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump and public schema