Re: quick q re execute & scope of new

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: quick q re execute & scope of new
Date: 2015-04-03 04:57:51
Message-ID: FA7D8299-36C5-4B94-9DAF-C8CB40F59C1C@elevated-dev.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 2, 2015, at 10:10 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2015-04-03 04:59:38 Re: quick q re execute & scope of new
Previous Message Adrian Klaver 2015-04-03 04:14:14 Re: quick q re execute & scope of new