Re: plpgsql function with offset - Postgres 9.1

[Patrick B <patrickbakerbr@xxxxxxxxx>]

2017-06-16 10:35 GMT+12:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Thu, Jun 15, 2017 at 3:19 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:

2017-05-29 19:27 GMT+12:00 Albe Laurenz <laurenz.albe@xxxxxxxxxx>:

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/CY1PR18MB0490632A9A73E64973F66D6BAFCE0%40CY1PR18MB0490.namprd18.prod.outlook.com

David J​

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.