DROP FUNCTION IF EXIST log_test();

    CREATE OR REPLACE FUNCTION log_test() RETURNS trigger AS $$

    DECLARE

    BEGIN

        RAISE NOTICE 'TRIGGER LOG TEST';

        RETURN NULL;

    END;

    $$ LANGUAGE plpgsql;

CREATE TRIGGER log_trigger

    AFTER UPDATE on emps

    FOR EACH ROW EXECUTE Procedure log_test();

UPDATE emps SET salary = 8000.0 WHERE userid = 10;

    CREATE VIEW salarys AS

        SELECT userid AS id, salary AS money

        FROM emps

        WHERE salary > 1000;

    SELECT * FROM VIEW;