How to find out if row was modified by EXECUTE UPDATE ...

Поиск
Список
Период
Сортировка
От A B
Тема How to find out if row was modified by EXECUTE UPDATE ...
Дата
Msg-id dbbf25901003080412v4db318a5lffa7ead76aae966f@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to find out if row was modified by EXECUTE UPDATE ...  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Hello.
Doesn't this work in plpgsql functions?

EXECUTE 'UPDATE mytable set ... ...'
IF FOUND THEN
       do stuff....
END IF;

It seems it always evaluate to false in the if statement, Isn't  found
used to see if an update has modified rows?

Are there any alternatives to selecting the row and see if the values
are set to see if the update worked?

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: XML Index again
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: How to find out if row was modified by EXECUTE UPDATE ...