/*
 * Support for plpgsql
 */
CREATE LANGUAGE 'plpgsql';

/*
 * Trigger function that keeps UpdateTime up to date
 */
CREATE OR REPLACE FUNCTION update_updatetime()
RETURNS TRIGGER
LANGUAGE plpgsql
AS $$
BEGIN
    NEW.UpdateTime= now();
    RETURN NEW;
END;
$$;

/*
 * Trigger function that keeps InsertTime up to date
 */
CREATE OR REPLACE FUNCTION update_inserttime()
RETURNS TRIGGER
LANGUAGE plpgsql
AS $$
BEGIN
    NEW.InsertTime= now();
    RETURN NEW;
END;
$$;