one trigger on postgres

CREATE FUNCTION user_stamp () RETURNS trigger AS $user_stamp$
    BEGIN
        NEW.lastupdate := 'now';
        RETURN NEW;
    END;
$user_stamp$ LANGUAGE plpgsql;


CREATE TRIGGER user_stamp BEFORE INSERT OR UPDATE ON fb_fy_user
    FOR EACH ROW EXECUTE PROCEDURE user_stamp();


   
ALTER FUNCTION user_stamp() OWNER TO postgres;
GRANT ALL ON FUNCTION user_stamp() TO adchap_test;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29753604/viewspace-1390872/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29753604/viewspace-1390872/