3 INSERT INTO config.upgrade_log (version) VALUES ('0104'); -- Scott McKellar
5 -- Create updatable view
7 CREATE OR REPLACE VIEW query.expr_string AS
19 CREATE OR REPLACE RULE query_expr_string_insert_rule AS
20 ON INSERT TO query.expr_string
22 INSERT INTO query.expression (
30 COALESCE(NEW.id, NEXTVAL('query.expression_id_seq'::REGCLASS)),
32 COALESCE(NEW.parenthesize, FALSE),
34 COALESCE(NEW.seq_no, 1),
38 CREATE OR REPLACE RULE query_expr_string_update_rule AS
39 ON UPDATE TO query.expr_string
41 UPDATE query.expression SET
43 parenthesize = NEW.parenthesize,
44 parent_expr = NEW.parent_expr,
50 CREATE OR REPLACE RULE query_expr_string_delete_rule AS
51 ON DELETE TO query.expr_string
53 DELETE FROM query.expression WHERE id = OLD.id;