Pastebin
Paste #1329: trigger
< previous paste - next paste>
Pasted by Anonymous Coward
/*
* Support for plpgsql
*/
CREATE LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL';
/*
* Trigger function that keeps mtime up to date
*/
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.