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 instance mentioned that the AFTER INSERT trigger should be VOLATILE. The question is how this words affect a for each row before insert trigger? Can be some optimisation here?
https://www.postgresql.org/docs/11/xfunc-volatility.html -- Adrian Klaver adrian.klaver@xxxxxxxxxxx