[GENERAL] CREATE RULE with WHERE clause

[Ranieri Mazili]

Hello,

I need to create a rule, but I need that it have a WHERE clause, how bellow:

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;

Someone knows how can I do it?

I appreciate any help

Thanks 


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly