1 -- Add left_operand column to query.expr_xcase view
3 -- If the view doesn't exist, this drop will fail, and that's okay
4 DROP VIEW query.expr_xcase CASCADE;
8 INSERT INTO config.upgrade_log (version) VALUES ('0304'); -- Scott McKellar
10 CREATE OR REPLACE VIEW query.expr_xcase AS
23 CREATE OR REPLACE RULE query_expr_xcase_insert_rule AS
24 ON INSERT TO query.expr_xcase
26 INSERT INTO query.expression (
35 COALESCE(NEW.id, NEXTVAL('query.expression_id_seq'::REGCLASS)),
37 COALESCE(NEW.parenthesize, FALSE),
39 COALESCE(NEW.seq_no, 1),
41 COALESCE(NEW.negate, false)
44 CREATE OR REPLACE RULE query_expr_xcase_update_rule AS
45 ON UPDATE TO query.expr_xcase
47 UPDATE query.expression SET
49 parenthesize = NEW.parenthesize,
50 parent_expr = NEW.parent_expr,
52 left_operand = NEW.left_operand,
57 CREATE OR REPLACE RULE query_expr_xcase_delete_rule AS
58 ON DELETE TO query.expr_xcase
60 DELETE FROM query.expression WHERE id = OLD.id;