Re: Please help

Hi Mike,

> Can anyone help me write a trigger on a table, I have
> created an audit table for a table and what I want
> trigger to do is to whenever a record is deleted from
> the table it should first be inserted into the audit
> table, just to keep track of whatever records are
> deleted.

Is this something ?? This archives my adres changes.

/* Archive function */
DROP FUNCTION fn_archive();
CREATE FUNCTION fn_archive() RETURNS OPAQUE AS '
BEGIN
/* TG_OP is the function (UPDATE, DELETE, SELECT) */
INSERT INTO adres_archive
VALUES (OLD.name,OLD.adres,OLD.tel,current_user,now(),tg_opt);
NEW.modtime := ''now'';
END IF;

RETURN NEW;
END;
' LANGUAGE 'plpgsql';

/* Archive trigger */
DROP TRIGGER tr_archive ON adres;
CREATE TRIGGER tr_adres_archive BEFORE UPDATE OR DELETE
ON adres FOR EACH ROW
EXECUTE PROCEDURE fn_archive ();

Ferdinand Smit