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: >
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.