Re: [SQL] rule's behavior with join interesting

On Wednesday 21 April 2004 21:07, Kemin Zhou wrote: Here I have a very simple case table1 table1_removed anotherTable create or replace RULE rec_remove as ON DELETE TO table1 do insert into table1_remove select old.*, a.acc from old g join anotherTable a on g.acc=a.other_acc; === the

Re: [SQL] rule's behavior with join interesting

Richard Huxton wrote: On Wednesday 21 April 2004 21:07, Kemin Zhou wrote: Here I have a very simple case table1 table1_removed anotherTable create or replace RULE rec_remove as ON DELETE TO table1 do insert into table1_remove select old.*, a.acc from old g join anotherTable a on

[SQL] rule's behavior with join interesting

Here I have a very simple case table1 table1_removed anotherTable create or replace RULE rec_remove as ON DELETE TO table1 do insert into table1_remove select old.*, a.acc from old g join anotherTable a on g.acc=a.other_acc; === the parser complained ERROR: relation *OLD* does not exist