Re: plpgsql lacks generic identifier for record in triggers...

>
> db=# CREATE FUNCTION schma.tbl_ins_upd() RETURNS TRIGGER AS 'BEGIN
> EXECUTE public.mc_init();
> EXECUTE public.mc_delete(''mc_key'');
> RETURN NEW;
> END;' LANGUAGE 'plpgsql';
> db=# CREATE FUNCTION schma.tbl_del() RETURNS TRIGGER AS 'BEGIN
> EXECUTE public.mc_init();
> EXECUTE public.mc_delete(''mc_key'');
> RETURN OLD;
> END;' LANGUAGE 'plpgsql';

could this be used?

CREATE FUNCTION schma.tbl_ins_upd() RETURNS TRIGGER AS 'BEGIN

EXECUTE public.mc_init();
EXECUTE public.mc_delete(''mc_key'');
if TG_OP = ''INSERT'' or TG_OP = ''UPDATE'' then
RETURN NEW;
else
RETURN OLD;
end if;
END;' LANGUAGE 'plpgsql';

regards

Laser