Re: stable for each row before insert trigger

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Олег Самойлов <splarv(at)ya(dot)ru>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: stable for each row before insert trigger
Date: 2019-10-17 23:41:58
Message-ID: e5ab4d39-5ea5-1124-cd05-e6a497fd0311@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 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(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-10-17 23:55:53 Re: drop database
Previous Message Олег Самойлов 2019-10-17 23:31:12 stable for each row before insert trigger