Re: [GENERAL] Trigger and arguments question

2005-05-27 Thread Stephan Szabo
On Thu, 26 May 2005, [iso-8859-1] Hervé Inisan wrote: > 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

Re: [GENERAL] Trigger and arguments question

2005-05-27 Thread Hervé Inisan
> Hervé Inisan wrote: > > 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(), a

Re: [GENERAL] Trigger and arguments question

2005-05-27 Thread Alban Hertroys
Hervé Inisan wrote: 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].

Re: [GENERAL] Trigger and arguments question

2005-05-26 Thread Jaime Casanova
On 5/26/05, Hervé Inisan <[EMAIL PROTECTED]> wrote: > > 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 myfu

[GENERAL] Trigger and arguments question

2005-05-26 Thread Hervé Inisan
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