Re: quick q re execute & scope of new - Mailing list pgsql-general

From Tom Lane
Subject Re: quick q re execute & scope of new
Date
Msg-id 14789.1428034206@sss.pgh.pa.us
Whole thread Raw
In response to quick q re execute & scope of new  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: quick q re execute & scope of new  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-general
Scott Ribe <scott_ribe@elevated-dev.com> writes:
> Easier to give an example than describe the question, any chance of making something like this work?
> execute('insert into ' || tblname || ' values(new.*)');

Not like that, for certain.  It might work to use EXECUTE ... USING new.*
or some variant of that.

            regards, tom lane


pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: quick q re execute & scope of new
Next
From: Adrian Klaver
Date:
Subject: Re: quick q re execute & scope of new