Re: Calculating a moving average (Coding style)

mstory(at)uchicago(dot)edu 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;
...
> RETURN OLD;
> ELSE
> y := y + NEW.bar;
...
> RETURN NEW;
> END IF;
> END;
> ' LANGUAGE plpgsql;

I see people do this from time to time. Just out of curiosity, is this
considered good coding style, or is it considered "lazyness"? I'm not
sure what to think of it.

If I would have written this, there would have been 3 triggers w/o the
check on TG_OP. Is there an important drawback to doing so? Is there any
document on "preferred" coding style in PL/PGSQL?

Yes, I'm a bit of a purist...

--
Regards,

Alban Hertroys
MAG Productions

T: +31(0)53 4346874
F: +31(0)53 4346876
E: alban(at)magproductions(dot)nl
W: http://www.magproductions.nl