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'-