How to send values from the changed row to a trigger in postgres?

Question

I want to create a trigger, somehow like this:

CREATE TRIGGER foo 
AFTER UPDATE OR INSERT ON bar 
FOR EACH ROW EXECUTE PROCEDURE baz(NEW.id);

The part with NEW.id doesn't work. How can I send values from the changed row (id for instance) to the trigger-function.

Erwin Brandstetter · Accepted Answer · 2011-11-04 19:21:34Z

2

The trigger function (procedure) knows NEW and OLD automatically. No need to pass those as parameters. Read more in the chapter on Trigger Procedures in the manual:

When a PL/pgSQL function is called as a trigger, several special variables are created automatically in the top-level block. They are:

NEW

Data type RECORD; variable holding the new database row for INSERT/UPDATE operations in row-level triggers. This variable is NULL in statement-level triggers and for DELETE operations.

edited Nov 4, 2011 at 19:21

answered Nov 4, 2011 at 19:16

Erwin Brandstetter

668k159 gold badges1.2k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to send values from the changed row to a trigger in postgres?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related