fuzz/fuzz_seeds/postgres_2433_create_rule.sql - datafusion-sqlparser-rs - Git at Google


            
            CREATE RULE r AS ON DELETE TO docs DO INSTEAD NOTHING;

            
            CREATE OR REPLACE RULE r AS ON SELECT TO t DO ALSO NOTHING;

            
            CREATE RULE r AS ON INSERT TO s1.t DO NOTHING;

            
            CREATE RULE r AS ON UPDATE TO t WHERE quantity > 100 DO ALSO INSERT INTO audit (id) VALUES (1);

            
            CREATE RULE r AS ON DELETE TO t DO INSTEAD (UPDATE t2 SET deleted = 1 WHERE id = 1; DELETE FROM t3)
	CREATE RULE r AS ON DELETE TO docs DO INSTEAD NOTHING;
	CREATE OR REPLACE RULE r AS ON SELECT TO t DO ALSO NOTHING;
	CREATE RULE r AS ON INSERT TO s1.t DO NOTHING;
	CREATE RULE r AS ON UPDATE TO t WHERE quantity > 100 DO ALSO INSERT INTO audit (id) VALUES (1);
	CREATE RULE r AS ON DELETE TO t DO INSTEAD (UPDATE t2 SET deleted = 1 WHERE id = 1; DELETE FROM t3)