Re: How to tell which event was fired in Trigger function

2018-07-11 Thread Igal @ Lucee.org
On 7/11/2018 11:02 AM, David G. Johnston wrote: On Wed, Jul 11, 2018 at 10:54 AM, Igal @ Lucee.org >wrote: On 7/11/2018 10:38 AM, Adrian Klaver wrote: On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote: How can I tell inside the trigger function if

Re: How to tell which event was fired in Trigger function

2018-07-11 Thread David G. Johnston
On Wed, Jul 11, 2018 at 10:54 AM, Igal @ Lucee.org wrote: > On 7/11/2018 10:38 AM, Adrian Klaver wrote: > >> On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote: >> >>> How can I tell inside the trigger function if the event was DELETE or >>> INSERT/UPDATE? >>> >> >>

Re: How to tell which event was fired in Trigger function

2018-07-11 Thread Igal @ Lucee.org
On 7/11/2018 10:38 AM, Adrian Klaver wrote: On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote: How can I tell inside the trigger function if the event was DELETE or INSERT/UPDATE? https://www.postgresql.org/docs/10/static/plpgsql-trigger.html This looks like it have all of the information that

Re: How to tell which event was fired in Trigger function

2018-07-11 Thread Adrian Klaver
On 07/11/2018 10:36 AM, Igal @ Lucee.org wrote: Hi, I am writing a trigger function that is used after DELETE, INSERT, and UPDATE, like so:     CREATE TRIGGER tr_name AFTER DELETE OR INSERT OR UPDATE ... How can I tell inside the trigger function if the event was DELETE or INSERT/UPDATE?