Re: Detecting which columns a query will modify in a function calledby a trigger

On 3/3/20 3:06 PM, David G. Johnston wrote:
> On Tue, Mar 3, 2020 at 3:48 PM Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>> wrote:
> 
>     The link was for automatically updateable views. If you want to do
>     something more involved then see:
> 
>     https://www.postgresql.org/docs/12/rules-views.html#RULES-VIEWS-UPDATE
> 
> 
> CREATE TRIGGER works with views; I usually see recommendations to start 
> there and avoid rules if at all possible.

The above suggests triggers then rules.

> 
> David J.


-- 
Adrian Klaver
adrian.klaver@aklaver.com