Re: simple trigger question ... - Mailing list pgsql-sql

From Tom Lane
Subject Re: simple trigger question ...
Date
Msg-id 25618.1049344429@sss.pgh.pa.us
Whole thread Raw
In response to Re: simple trigger question ...  ("Marc G. Fournier" <scrappy@hub.org>)
Responses Re: simple trigger question ...  ("Marc G. Fournier" <scrappy@hub.org>)
List pgsql-sql
"Marc G. Fournier" <scrappy@hub.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



pgsql-sql by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: simple trigger question ...
Next
From: "mohamed imdadullah"
Date:
Subject: Syntax problem!