I have a trigger like this:
CREATE TRIGGER mytrigger
AFTER INSERT OR UPDATE OR DELETE
FOR EACH ROW
EXECUTE PROCEDURE myschema.myfunction(myarg);
It sends an argument to myfunction(), and I can retrieve this value in
What I'm trying to do is using TG_ARGV to point to a field in NEW or OLD.
Is it possible?
Something like NEW.TG_ARGV...
I'm trying to write a kind of generic function which I could use on multiple
tables with different field names (myarg being the field name).
But I can't get it to work.
Any clues or other solutions?
-- Hervé Inisan.
pgsql-general by date
|Next:||From: Tom Lane||Date: 2005-05-26 20:29:44|
|Subject: Re: another failover testing question |
|Previous:||From: Vivek Khera||Date: 2005-05-26 19:48:08|
|Subject: Re: pg_listener records|