postgreSQL create rule on select where clause -

i assistance on syntax on creating rule includes clause.

here have far

create rule coderetrieve       on select rc.code rc rc.codeid = fromquery.codeid     instead       rcaa.code rcaa rcaa.codeid = fromquery.codeid    

basically, default want redirect query 1 table , return results rcaa table.

reason? avoid going thru code in gazillion places , changing query. wanted experiment changing code in 1 place, i.e. database rule.

thanks.

to redirec query old table new table maybe don't need rule ddl , plane old sql. if rename table rc (for example in "_rc") , create view rc select * rcaa (eventually "where" filter) gazillion lines of code need no change select query. in case of need of action query can add rule on rc view.