Trigger and arguments question - Mailing list pgsql-general

From Hervé Inisan
Subject Trigger and arguments question
Date
Msg-id 20050526194951.1247A317E58@postfix4-1.free.fr
Whole thread Raw
Responses Re: Trigger and arguments question
Re: Trigger and arguments question
Re: Trigger and arguments question
List pgsql-general
Hi everybody!

I have a trigger like this:

CREATE TRIGGER mytrigger
   AFTER INSERT OR UPDATE OR DELETE
   ON myschema.mytable
   FOR EACH ROW
   EXECUTE PROCEDURE myschema.myfunction(myarg);

It sends an argument to myfunction(), and I can retrieve this value in
TG_ARGV[0]. Fine.
What I'm trying to do is using TG_ARGV[0] to point to a field in NEW or OLD.
Is it possible?

Something like NEW.TG_ARGV[0]...

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?
Thanks,
-- Hervé Inisan.



pgsql-general by date:

Previous
From: Vivek Khera
Date:
Subject: Re: pg_listener records
Next
From: Tom Lane
Date:
Subject: Re: another failover testing question