Re: Trigger question: ROW or STATEMENT?

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Patrick Hatcher <PHatcher(at)macys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger question: ROW or STATEMENT?
Date: 2006-01-25 21:36:07
Message-ID: 87d5iggfco.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Patrick Hatcher <PHatcher(at)macys(dot)com> writes:

> Here is the trigger the way it is currently written. I add some additional
> information from another table:

If you're modifying each row before it goes in, it should definitely
be a FOR EACH ROW trigger.

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Buttafuoco 2006-01-25 22:08:48 Re: My very first PL/pgSQL procedure...
Previous Message Aly Dharshi 2006-01-25 21:31:55 Re: Postgresql Segfault in 8.1