Yes.
CREATE FUNCTION "last_updated" () RETURNS TRIGGER AS '
BEGIN
NEW.stamp = now();
RETURN NEW;
END;
' LANGUAGE 'plpgsql';
CREATE TRIGGER update_stamp AFTER UPDATE OR INSERT ON table FOR EACH ROW EXECUTE PROCEDURE
last_updated();
regds
mallah.
> Hello list,
>
> Is there a way to write a common/generic trigger function for multiple tables to save in a
> column (stamp) the last time a row was inserted or modified.
>
>
> --
> Sinceramente,
> Josué Maldonado.
>
> "Tiene la ciencia sus hipócritas, no menos que la virtud, y no menos es engañado el vulgo por
> aquéllos que por éstos. Son muchos los indoctos que pasan plaza de sabios." Jerónimo Feijoo.
> Escritor español.
>
> ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to
> increase your free space map settings
>
> !DSPAM:4133576a86001177520034!
-----------------------------------------
Over 1,00,000 exporters are waiting for your order! Click below to get
in touch with leading Indian exporters listed in the premier
trade directory Exporters Yellow Pages.
http://www.trade-india.com/dyn/gdh/eyp/