From: | stan <stanb(at)panix(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: A question about the number of times a trigger will fire |
Date: | 2020-03-05 18:05:16 |
Message-ID: | 20200305180516.GA28124@panix.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(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
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-03-05 18:34:02 | Re: Getting a error on creating a partition table index 12.2. |
Previous Message | nikhil raj | 2020-03-05 18:04:38 | Getting a error on creating a partition table index 12.2. |