3 INSERT INTO config.upgrade_log (version) VALUES ('0256'); -- Scott McKellar
5 -- Create updatable view for bind variable expressions
7 CREATE OR REPLACE VIEW query.expr_xbind AS
19 CREATE OR REPLACE RULE query_expr_xbind_insert_rule AS
20 ON INSERT TO query.expr_xbind
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_xbind_update_rule AS
39 ON UPDATE TO query.expr_xbind
41 UPDATE query.expression SET
43 parenthesize = NEW.parenthesize,
44 parent_expr = NEW.parent_expr,
46 bind_variable = NEW.bind_variable
50 CREATE OR REPLACE RULE query_expr_xbind_delete_rule AS
51 ON DELETE TO query.expr_xbind
53 DELETE FROM query.expression WHERE id = OLD.id;