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

Go to most recent paste.

Backed by:

PostgreSQL Professional Services

Debian Linux Support