Re: triggers and parameters - Mailing list pgsql-novice

From Roger Mason
Subject Re: triggers and parameters
Date
Msg-id y657dgdbtt9.fsf@mun.ca
Whole thread Raw
In response to Re: triggers and parameters  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-novice
David G. Johnston writes:

> If jid is on the table "results" then you are good [1].  If not, how
> exactly would expect that to work?
>
> https://www.postgresql.org/docs/current/plpgsql-trigger.html#PLPGSQL-DML-TRIGGER

OK, I think I understand better now.  The NEW record holds the new data
and the trigger function can extract the items it needs from that
record.

Thanks - inviting me to read the docs more carefully was just what I
needed.

Roger



pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: triggers and parameters
Next
From: Sruthi V
Date:
Subject: postgres sql service not running