PasteBin on this domain is being retired. Please use PasteBin on paste.adora.dk instead.

Pastebin

Paste #1329: trigger

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;
$$;

Paste below

Go to most recent paste.