Re: plpgsql function with offset - Postgres 9.1

On Thu, Jun 15, 2017 at 3:49 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:

> 2017-06-16 10:35 GMT+12:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:
>
>> On Thu, Jun 15, 2017 at 3:19 PM, Patrick B <patrickbakerbr(at)gmail(dot)com>
>> wrote:
>>
>>> 2017-05-29 19:27 GMT+12:00 Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>:
>>>
>>>> Patrick B wrote:
>>>> > I am running a background task on my DB, which will copy data from
>>>> tableA to tableB. For
>>>> > that, I'm writing a PL/PGSQL function which basically needs to do the
>>>> following:
>>>> >
>>>
>>>
>> ​https://www.postgresql.org/message-id/CY1PR18MB0490632A9A73
>> E64973F66D6BAFCE0%40CY1PR18MB0490.namprd18.prod.outlook.com
>>
>> My problem is when using LIMIT to select the data I get none. I assume
> because the first 3000 rows (i'm using ORDER BY 1) are not candidates for
> the migration.
>

Your where clause should only allow candidates to be selected. If it does
then your theory is wrong.

David J.​