Re: stable for each row before insert trigger - Mailing list pgsql-general

From Adrian Klaver
Subject Re: stable for each row before insert trigger
Date
Msg-id e5ab4d39-5ea5-1124-cd05-e6a497fd0311@aklaver.com
Whole thread Raw
In response to stable for each row before insert trigger  (Олег Самойлов <splarv@ya.ru>)
Responses Re: stable for each row before insert trigger
List pgsql-general
On 10/17/19 4:31 PM, Олег Самойлов wrote:
> Hi all.
> 
> According to documentation the words "VOLATILE, STABLE, IMMUTABLE" is somehow useful with trigger functions, for
instancementioned that the AFTER INSERT trigger should be VOLATILE. The question is how this words affect a for each
rowbefore insert trigger? Can be some optimisation here?
 
> 
> 

https://www.postgresql.org/docs/11/xfunc-volatility.html

-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Олег Самойлов
Date:
Subject: stable for each row before insert trigger
Next
From: Ron
Date:
Subject: Re: drop database