Re: simple trigger question ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: simple trigger question ...
Date: 2003-04-03 04:33:49
Message-ID: 25618.1049344429@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Marc G. Fournier" <scrappy(at)hub(dot)org> writes:
> Okay, so I do have to create the FUNCTION first, I can't do it without?

Check.

> Can a TRIGGER pass an arg to the FUNCTION?

Yes, but only simple constant strings. (In this context, it might
make sense for the CREATE TRIGGER command to tell the function the
name of the specific sequence to increment.)

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Hugh Krenske 2003-04-03 07:23:33 auto-commit
Previous Message Marc G. Fournier 2003-04-03 04:31:20 Re: simple trigger question ...