hello i'm using postgres 7.2.1
and i'm using rule
example:
create rule test_rule
as on insert to test
do instead
(insert into test2
(select NEW.id where NEW.id='1'));
this works but the return string in psql is false
example:
insert into test(id) values ('2');
INSERT 0 0
normal, '2' is different from '1'
but
insert into test(id) values ('1');
INSERT 0 0
bug, it instert a line in table test2
select * from test2;
id
----
1
so the return must be
INSERT 0 1
IS IT A BUG?
sylvain