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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Дата
Msg-id CAKFQuwagNwxhZgKSy0+TL-kcwx91g9aLdP077c-3zw213ZXKww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3  (Patrick Baker <patrickbakerbr@gmail.com>)
Ответы Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3  (Patrick B <patrickbakerbr@gmail.com>)
Список pgsql-general
On Thu, Jun 2, 2016 at 11:59 PM, Patrick Baker <patrickbakerbr@gmail.com> wrote:


2016-06-03 15:50 GMT+12:00 David G. Johnston <david.g.johnston@gmail.com>:
On Thu, Jun 2, 2016 at 11:37 PM, Patrick Baker <patrickbakerbr@gmail.com> 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

​Add a counter variable, increment it within the loop, and return it.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: PL/PGSQL + inserts+updates+limit - Postgres 9.3
Следующее
От: Leonardo M. Ramé
Дата:
Сообщение: Re: Londiste3 - Ubuntu 16.04 - Postgresql 9.3