Re: quick q re execute & scope of new

On 04/02/2015 08:30 PM, Scott Ribe wrote:
> Easier to give an example than describe the question, any chance of making something like this work?

You doing this in plpgsql trigger function I presume?

>
> execute('insert into ' || tblname || ' values(new.*)');
>

So
http://www.postgresql.org/docs/9.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN:

EXECUTE 'insert into ' || quote_ident(tblname) || ' values(' || new.* || ')'

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com