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();