Re: triggers and parameters

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Roger Mason <rmason(at)mun(dot)ca>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: triggers and parameters
Date: 2021-08-22 03:24:36
Message-ID: CAKFQuwaCBSS0BGyWpk7wNDjnKOmse0JGYnGZgze=Dx4GefWFnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Aug 21, 2021 at 7:13 PM Roger Mason <rmason(at)mun(dot)ca> wrote:

> I want to pass a parameter (jid) that will be different for every
> invocation of 'foo_insert'.

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

David J.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Roger Mason 2021-08-22 11:30:26 Re: triggers and parameters
Previous Message Roger Mason 2021-08-21 15:04:36 triggers and parameters