Pastebin

Paste #992: sql trigger

< previous paste - next paste>

Pasted by tdn

Download View as text

CREATE TRIGGER update_mtime
	AFTER UPDATE ON customer
	FOR EACH ROW EXECUTE PROCEDURE CREATE OR REPLACE FUNCTION update_mtime RETURNS TRIGGER LANGUAGE plpgsql AS $$BEGIN NEW.mtime = now(); RETURN NEW; END;$$;;

New Paste


Do not write anything in this field if you're a human.

Go to most recent paste.