From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Harpreet Dhaliwal <harpreet(dot)dhaliwal01(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Passing arguments to a trigger function |
Date: | 2006-08-22 20:29:07 |
Message-ID: | 20060822202907.GA58475@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Aug 22, 2006 at 01:18:44PM -0400, Harpreet Dhaliwal wrote:
> Can anyone give me pointers for how to pass arguments to a trigger function.
> I think it is done using tg_argv or something but not very sure how to do
> it.
Here's an example:
CREATE TABLE foo (id integer PRIMARY KEY, t text, x integer);
CREATE TABLE bar (id integer PRIMARY KEY, t text, x integer);
CREATE FUNCTION trigfunc() RETURNS trigger AS $$
BEGIN
NEW.t := TG_ARGV[0];
NEW.x := TG_ARGV[1];
RETURN NEW;
END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER footrig BEFORE INSERT OR UPDATE ON foo
FOR EACH ROW EXECUTE PROCEDURE trigfunc('test on foo', 123);
CREATE TRIGGER bartrig BEFORE INSERT OR UPDATE ON bar
FOR EACH ROW EXECUTE PROCEDURE trigfunc('test on bar', 456);
INSERT INTO foo (id) VALUES (1);
SELECT * FROM foo;
id | t | x
----+-------------+-----
1 | test on foo | 123
(1 row)
INSERT INTO bar (id) VALUES (1);
SELECT * FROM bar;
id | t | x
----+-------------+-----
1 | test on bar | 456
(1 row)
--
Michael Fuhr
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-08-22 20:30:15 | Re: [HACKERS] Queries joining views |
Previous Message | John Gray | 2006-08-22 20:24:32 | Re: [GENERAL] pgxml & xpath_table |