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

On 7/11/2018 11:02 AM, David G. Johnston wrote:
> On Wed, Jul 11, 2018 at 10:54 AM, Igal @ Lucee.org <igal(at)lucee(dot)org
> <mailto:igal(at)lucee(dot)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?
>
>
> https://www.postgresql.org/docs/10/static/plpgsql-trigger.html
> <https://www.postgresql.org/docs/10/static/plpgsql-trigger.html>
>
>
> This looks like it have all of the information that I need.  For
> some reason search engines bring up many other pages but not that one.
>
>
> ​For these situations I recommend bookmarking and navigating to the
> Table of Contents [1] for the documentation and looking for relevant
> chapter titles - in this case the "V. 38 - Triggers" one is right
> there on the main page.
>
> https://www.postgresql.org/docs/10/static/index.html
>
> On a related note, maybe the pl/pgsql link from the Triggers chapter
> should link directly to the Triggers section under pl/pgsql instead of
> the top of the chapter...

+1

Should link to ¶42.9 -
https://www.postgresql.org/docs/10/static/plpgsql-trigger.html