Re: INSERT RULE

From: Pailloncy Jean-Gérard <pailloncy(at)gdr-isis(dot)enst(dot)fr>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: INSERT RULE
Date: 2004-05-04 10:13:26
Message-ID: AEF2EF5C-9DB3-11D8-95E2-000A95DE2550@gdr-isis.enst.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • INSERT RULE at 2004-05-03 20:58:28 from Pailloncy Jean-Gérard

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Aaron Werman 2004-05-04 12:06:22 Re: linux distro for better pg performance
Previous Message Mark Kirkwood 2004-05-04 07:39:22 Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!