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
> 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
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].
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
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