"Martin Blazek" <mblazek@8bc.com> writes:
> CREATE FUNCTION test() RETURNS integer AS $$
> BEGIN
> CREATE RULE "rule" AS ON INSERT TO "test" DO INSTEAD INSERT INTO "test"
> VALUES (1);
> END;$$ LANGUAGE plpgsql;
Hm, I guess nobody ever tried to do that in plpgsql before. It's
taking the INTO as starting a clause that returns values into plpgsql
variables :-(.
There's a special case in there to prevent INTO just after INSERT
from being taken that way, but it only works when the INSERT is at
the start of the statement :-(. Guess we need to change that.
In the meantime, you can probably work around this by using EXECUTE,
ie
EXECUTE 'CREATE RULE "rule" AS ON INSERT TO "test" DO INSTEAD INSERT INTO "test" VALUES (1)';
regards, tom lane