arguments passed to a trigger function

Started by Louis-David Mitterrandalmost 26 years ago3 messagesgeneral
Jump to latest
#1Louis-David Mitterrand
cunctator@apartia.ch

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Louis-David Mitterrand (#1)
Re: arguments passed to a trigger function

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
#3Bruce Momjian
bruce@momjian.us
In reply to: Louis-David Mitterrand (#1)
Re: arguments passed to a trigger function

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