Re: Function with limit and offset - PostgreSQL 9.3

On Thursday, June 8, 2017, marcinha rocha <marciaestefanidarocha(at)hotmail(dot)com<mailto:marciaestefanidarocha(at)hotmail(dot)com>> wrote:

On my original select, the row will have migrated = false. Maybe All I need to put is a limit 2000 and the query will do the rest?

You shoud try to avoid the for loop,

Why?

but yes a limit 2000 on the for loop query should work since the migrated flag will ensure the same rows aren't selected again.

David J.

Ok, cool!

Now, how do tell the function to return the number of touched rows? On this case, it should always be 2000.

Thanks!