Re: [GENERAL] CREATE RULE with WHERE clause

2007-06-05 Thread Michael Glaesemann
On Jun 5, 2007, at 8:11 , Ranieri Mazili wrote: CREATE RULE rule_role_sul AS ON SELECT TO t1 WHERE roles = 'role_sul' DO INSTEADSELECT field1, field2 FROM t2; CREATE RULE rule_role_sul AS ON SELECT TO t1 WHERE roles = 'role_norte' DO INSTEADSELECT field3, field4 FRO

Re: [GENERAL] CREATE RULE with WHERE clause

2007-06-05 Thread Richard Broersma Jr
> CREATE RULE rule_role_sul AS > ON SELECT TO t1 WHERE roles = 'role_sul' > DO INSTEAD > SELECT field1, field2 FROM t2; > > CREATE RULE rule_role_sul AS > ON SELECT TO t1 WHERE roles = 'role_norte' > DO INSTEAD > SELECT field3, field4 FROM t2; From: http://www.po