Postgres Pro
Downloads
Home   >   mailing lists

Thread: arguments passed to a trigger function

arguments passed to a trigger function

From
Louis-David Mitterrand
Date:
In the create_trigger man page:

           EXECUTE PROCEDURE func ( arguments )

But what kind of arguments can be passed? It is not explained in the
documentation.

After looking at regress.c I undestand that these arguments are
contained in TriggerData->tg_trigger->tgargs but I can't seem to pass
anything useful to the procedure beyond random text strings at the
"CREATE TRIGGER ... " stage.

Thanks in advance for your insight,

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr

Re: arguments passed to a trigger function

From
Bruce Momjian
Date:
See the Programmer's Manual for examples.


> In the create_trigger man page:
>
>            EXECUTE PROCEDURE func ( arguments )
>
> But what kind of arguments can be passed? It is not explained in the
> documentation.
>
> After looking at regress.c I undestand that these arguments are
> contained in TriggerData->tg_trigger->tgargs but I can't seem to pass
> anything useful to the procedure beyond random text strings at the
> "CREATE TRIGGER ... " stage.
>
> Thanks in advance for your insight,
>
> --
> Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: arguments passed to a trigger function

From
Bruce Momjian
Date:
Seem my book at:

    http://www.postgresql.org/docs/awbook.html


> In the create_trigger man page:
>
>            EXECUTE PROCEDURE func ( arguments )
>
> But what kind of arguments can be passed? It is not explained in the
> documentation.
>
> After looking at regress.c I undestand that these arguments are
> contained in TriggerData->tg_trigger->tgargs but I can't seem to pass
> anything useful to the procedure beyond random text strings at the
> "CREATE TRIGGER ... " stage.
>
> Thanks in advance for your insight,
>
> --
> Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026