Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] plpgsql function with offset - Postgres 9.1 - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] plpgsql function with offset - Postgres 9.1
Date
Msg-id CAKFQuwbLBZrcEfP+GgAS-TLh_oZmz6HUtMXcpKAxErD3UU1jSg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] plpgsql function with offset - Postgres 9.1  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-general
Tree view
On Thu, Jun 15, 2017 at 3:49 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
2017-06-16 10:35 GMT+12:00 David G. Johnston <david.g.johnston@gmail.com>:
On Thu, Jun 15, 2017 at 3:19 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
2017-05-29 19:27 GMT+12:00 Albe Laurenz <laurenz.albe@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:
>


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

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: [GENERAL] plpgsql function with offset - Postgres 9.1
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Connection options