Re: [HACKERS] about RULES

> 
>     In  the case of a qualified instead rule, the parsetree get's
>     splitted.  One with the qual, one with the negated  qual.  If
>     you  only  want  'SALESMAN's,  you must put the qualification
>     into the INSERT action of the rule as
> 
>     create rule "_INSvista" as on insert to vista
>         do instead
>         insert into emp select new.empno, new.ename, new.job
>         where new.job='SALESMAN';

I see that rules is more complex than I thougth. 

I tried your example Jan but it doesn't work...

create rule "_INSvista" as on insert to vista     do instead     insert into emp select new.empno, new.ename, new.job
 where new.job='SALESMAN';
 
ERROR:  Type of empno does not match target column ename

-Jose'-