Re: Automate copy - Postgres 9.2

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Automate copy - Postgres 9.2
Date: 2016-06-09 04:50:23
Message-ID: 814d05d3-cfd4-0097-676a-2c3a8b0bb4c8@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/8/2016 7:04 PM, Patrick B wrote:
>
> FOR crtRow in EXECUTE 'select DISTINCT(account_id) from
> backup_table WHERE migrated = 1 AND account_id IN '|| $1
>

where .... and account_id in 21;

? I don't think that's what you want.

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Beverley 2016-06-09 06:10:34 Optimise OR condiditions across multiple joins
Previous Message David G. Johnston 2016-06-09 03:50:56 Re: Automate copy - Postgres 9.2