Generic/Common trigger

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/