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

From Scott Ribe
Subject Re: quick q re execute & scope of new
Date
Msg-id FA7D8299-36C5-4B94-9DAF-C8CB40F59C1C@elevated-dev.com
Whole thread Raw
In response to Re: quick q re execute & scope of new  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Apr 2, 2015, at 10:10 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Not like that, for certain.  It might work to use EXECUTE ... USING new.*
> or some variant of that.

Couldn't get a variant of that to work, but this did:

execute('insert into ' || tblnm || ' select $1.*') using new;

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







pgsql-general by date:

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