Re: [PERFORM] INSERT RULE

2004-05-05 Thread Pailloncy Jean-Gérard
I try to do: CREATE RULE ndicti AS ON INSERT TO ndict DO INSTEAD INSERT INTO 'ndict_' || (NEW.word_id 255) VALUES( NEW.url_id, NEW.word_id, NEW.intag); I got an error on 'ndict_' . I did not found the right syntax. In fact I discover that SELECT * FROM / INSERT INTO table doesn't accept

[PERFORM] INSERT RULE

2004-05-03 Thread Pailloncy Jean-Gérard
Hi, I test a configuration where one table is divided in 256 sub-table. And I use a RULE to offer a single view to the data. For INSERT I have create 256 rules like: CREATE RULE ndicti_000 AS ON INSERT TO ndict WHERE (NEW.word_id 255) = 000 DO INSTEAD INSERT INTO ndict_000 VALUES(