Re: INSERT RULE - Mailing list pgsql-performance

From Pailloncy Jean-Gérard
Subject Re: INSERT RULE
Date
Msg-id AEF2EF5C-9DB3-11D8-95E2-000A95DE2550@gdr-isis.enst.fr
Whole thread Raw
In response to INSERT RULE  (Pailloncy Jean-Gérard <pailloncy@gdr-isis.enst.fr>)
Responses Re: INSERT RULE
List pgsql-performance
> 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 function that returns the name of the table as table,
but only function that returns rows....

I'm dead.

Does this feature, is possible or plan ?
Is there a trick to do it ?

Cordialement,
Jean-Gérard Pailloncy


pgsql-performance by date:

Previous
From: "Jie Liang"
Date:
Subject: 7.4.2 out of memory
Next
From: "Jie Liang"
Date:
Subject: LIKE and INDEX