All pastes #514808 Raw Edit

Stuff

public sql v1 · immutable
#514808 ·published 2007-05-27 22:27 UTC
rendered paste body
CREATE OR REPLACE FUNCTION trig_su_while() RETURNS trigger AS $trig_su_while$    DECLARE        i INTEGER;    BEGIN	i := 0;	WHILE i < 1 LOOP	    INSERT INTO temp( hash ) VALUES( MD5( RANDOM() ) );	    i := i + 1;        END LOOP;        RETURN NEW;    END;$trig_su_while$ LANGUAGE plpgsql;CREATE TRIGGER trig_su_while AFTER UPDATE ON temp    EXECUTE PROCEDURE trig_su_while();        CREATE OR REPLACE FUNCTION trig_su_if() RETURNS trigger AS $trig_su_if$    BEGIN	IF 1=1 THEN	    INSERT INTO temp( hash ) VALUES( MD5( RANDOM() ) );        END IF;        RETURN NEW;    END;$trig_su_if$ LANGUAGE plpgsql;CREATE TRIGGER trig_su_if AFTER UPDATE ON temp    EXECUTE PROCEDURE trig_su_if();            CREATE OR REPLACE FUNCTION trig_be_k_strukt() RETURNS trigger AS $trig_be_k_strukt$    BEGIN	INSERT INTO temp( hash ) VALUES( MD5( RANDOM() ) );        RETURN NEW;    END;$trig_be_k_strukt$ LANGUAGE plpgsql;CREATE TRIGGER trig_be_k_strukt AFTER UPDATE ON temp    EXECUTE PROCEDURE trig_be_k_strukt();