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

From: A B <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to find out if row was modified by EXECUTE UPDATE ...
Date: 2010-03-08 12:12:32
Message-ID: dbbf25901003080412v4db318a5lffa7ead76aae966f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2010-03-08 12:18:16 Re: How to find out if row was modified by EXECUTE UPDATE ...
Previous Message Alban Hertroys 2010-03-08 11:33:19 Re: XML Index again