Request a Demo
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 <[email protected]>)
List pgsql-general
Tree view
On Thu, Jun 15, 2017 at 3:49 PM, Patrick B <[email protected]> wrote:
2017-06-16 10:35 GMT+12:00 David G. Johnston <[email protected]>:
On Thu, Jun 15, 2017 at 3:19 PM, Patrick B <[email protected]> wrote:
2017-05-29 19:27 GMT+12:00 Albe Laurenz <[email protected]>:
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