3 INSERT INTO config.upgrade_log (version) VALUES ('0298'); -- Scott McKellar
5 -- Create updatable view for BETWEEN expressions
7 DROP VIEW query.expr_xbet CASCADE;
9 CREATE OR REPLACE VIEW query.expr_xbet AS
22 CREATE OR REPLACE RULE query_expr_xbet_insert_rule AS
23 ON INSERT TO query.expr_xbet
25 INSERT INTO query.expression (
34 COALESCE(NEW.id, NEXTVAL('query.expression_id_seq'::REGCLASS)),
36 COALESCE(NEW.parenthesize, FALSE),
38 COALESCE(NEW.seq_no, 1),
40 COALESCE(NEW.negate, false)
43 CREATE OR REPLACE RULE query_expr_xbet_update_rule AS
44 ON UPDATE TO query.expr_xbet
46 UPDATE query.expression SET
48 parenthesize = NEW.parenthesize,
49 parent_expr = NEW.parent_expr,
51 left_operand = NEW.left_operand,
56 CREATE OR REPLACE RULE query_expr_xbet_delete_rule AS
57 ON DELETE TO query.expr_xbet
59 DELETE FROM query.expression WHERE id = OLD.id;