How to tell which event was fired in Trigger function - Mailing list pgsql-general

From Igal @ Lucee.org
Subject How to tell which event was fired in Trigger function
Date
Msg-id a389c8ed-ad53-8622-2b16-2f0c84141d25@lucee.org
Whole thread Raw
Responses Re: How to tell which event was fired in Trigger function
List pgsql-general

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? 

The table has a `NOT NULL id` column, so I am thinking that maybe a DELETE will have a NULL value in NEW.id?  Will that work?  Is there a better way?

Thanks,

Igal Sapir
Lucee Core Developer
Lucee.org

pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Using CTE vs temporary tables
Next
From: Adrian Klaver
Date:
Subject: Re: How to tell which event was fired in Trigger function