Postgres Pro
Downloads
Home   >   mailing lists

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

From Patrick B
Subject Re: [GENERAL] plpgsql function with offset - Postgres 9.1
Date
Msg-id CAJNY3ivEb6Ybb_yeqFGd2-2pen4xwO_4PM=PcL3CBQqrY-FDwg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] plpgsql function with offset - Postgres 9.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: [GENERAL] plpgsql function with offset - Postgres 9.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view


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


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.


pgsql-general by date:

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