On Thu, Jun 15, 2017 at 3:49 PM, Patrick B <patrickbake...@gmail.com> wrote:
> 2017-06-16 10:35 GMT+12:00 David G. Johnston <david.g.johns...@gmail.com>: > >> On Thu, Jun 15, 2017 at 3:19 PM, Patrick B <patrickbake...@gmail.com> >> wrote: >> >>> 2017-05-29 19:27 GMT+12:00 Albe Laurenz <laurenz.a...@wien.gv.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.
