Re: simple trigger question ...

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: simple trigger question ...
Дата
Msg-id 20030403061142.V72033@hub.org
обсуждение исходный текст
Ответ на Re: simple trigger question ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: simple trigger question ...  (Rod Taylor <rbt@rbt.ca>)
Re: simple trigger question ...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
On Wed, 2 Apr 2003, Tom Lane wrote:

> "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.)

'K, that makes it workable ... final question (I hope!) ... RULEs vs
TRIGGERs?  I ended up doing it as a RULE, since I could do it without a
function ... but is there a reason why that is a Bad Idea?  Or in a case
like this, it doesn't really matter?



В списке pgsql-sql по дате отправления:

Предыдущее
От: Christoph Haller
Дата:
Сообщение: Re: Syntax problem!
Следующее
От: "Jose Luis LG"
Дата:
Сообщение: unsubscribe