I personally use 3 seperate triggers on most occasions, depending on how
different the action for each seperate action is, it's just easier for me and my
people to logically distinguish the functions that way, but the example in the
7.4 documentation for triggers is given using the form that i wrot
On Mon, 24 Jan 2005 08:32 pm, Alban Hertroys wrote:
> [EMAIL PROTECTED] wrote:
> > CREATE OR REPLACE FUNCTION get_bar_avg() RETURNS TRIGGER AS '
> > DECLARE
> > bar_record RECORD;
> > x INTEGER;
> > y DOUBLE PRECISION := 0;
> > BEGIN
> > IF TG_OP = ''INSERT'' THEN
> > y := y + NEW.ba
[EMAIL PROTECTED] wrote:
CREATE OR REPLACE FUNCTION get_bar_avg() RETURNS TRIGGER AS '
DECLARE
bar_record RECORD;
x INTEGER;
y DOUBLE PRECISION := 0;
BEGIN
IF TG_OP = ''INSERT'' THEN
y := y + NEW.bar;
...
RETURN NEW;
ELSIF TG_OP = ''DELETE'' THEN
x := 0;
...