Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 3:22 PM David G. Johnston wrote: > On Mon, May 2, 2022 at 11:14 AM PG Doc comments form < > nore...@postgresql.org> wrote: > >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/13/trigger-datachanges.html >> Des

Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 7:11 PM David G. Johnston wrote: > On Mon, May 2, 2022 at 6:55 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Mon, May 2, 2022 at 6:33 PM Josh Silver >> wrote: >> > And, given the existing length and depth of content of that page already > I'm doubtful

Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 4:53 PM David G. Johnston wrote: > On Mon, May 2, 2022 at 4:42 PM Josh Silver wrote: > >> On Mon, May 2, 2022 at 3:22 PM David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >>> On Mon, May 2, 2022 at 11:14 AM PG Doc comments form < >>> nore...@postgresql.org> wrot

Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 6:55 PM David G. Johnston wrote: > On Mon, May 2, 2022 at 6:33 PM Josh Silver wrote: > >> >> and the 'Overview of Trigger Behavior pages says of before triggers >> >>> In row-level triggers the WHEN condition can examine the old and/or new >>> values of columns of the row

Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 6:33 PM Josh Silver wrote: > > and the 'Overview of Trigger Behavior pages says of before triggers > >> In row-level triggers the WHEN condition can examine the old and/or new >> values of columns of the row. (Statement-level triggers can also have >> WHEN conditions, alth

Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 4:42 PM Josh Silver wrote: > On Mon, May 2, 2022 at 3:22 PM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Mon, May 2, 2022 at 11:14 AM PG Doc comments form < >> nore...@postgresql.org> wrote: >> >>> The following documentation comment has been logged on t

Re: Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

On Mon, May 2, 2022 at 11:14 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/trigger-datachanges.html > Description: > > UPDATE test SET alpha = 5; > > only trigger b2_ab will fire, even though it wi

Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/trigger-datachanges.html Description: This caught me out because I was looking at the wrong page, so I figured it might be a good addition. I'm running version 'PostgreSQL 13.2 (Debian 13.