On Tue, Jun 17, 2008 at 3:46 AM, Klint Gore <kgore4@une.edu.au> wrote:
> The only way I could find to make this work is to use a rule and wrap the
> inner "insert returning" in a function.
Thanks, this works! Although it feels like something of a hack;
shouldn't there be a more elegant solution?
Also, I don't understand why
> create rule atest as on insert to studentinfo do instead (
> insert into student (person_id) select (select person_id from newperson(new));
> );
is necessary; what is wrong with
create rule atest as on insert to studentinfo do instead (
insert into student (person_id) select person_id from newperson(new);
);
? (Other than the evident fact that it doesn't work; the error
message "function expression in FROM cannot refer to other relations
of same query level" is not illuminating to me.)
Additionally, is there a reason why you put one of the inserts in the
function and the other in the rule? Why not have the function do both
inserts and then the rule just invoke the function?
Mike