Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3

[Patrick Baker <patrickbakerbr@xxxxxxxxx>]

2016-06-03 15:50 GMT+12:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Thu, Jun 2, 2016 at 11:37 PM, Patrick Baker <patrickbakerbr@xxxxxxxxx> wrote:

How can I make the function to gets the next 3 rows and not use the same rows that have been used before?

​WHERE migrated = 0

​

​David J.

lol... that's right David J. Thanks for that! it's working... ;)

Last thing.. how to select the number of rows that have been modified?

I mean.. when doing: select function_data_1():

I want to get back the number of rows that have been touched.. 

do u know how ?

thanks again