Thread: How to find out if row was modified by EXECUTE UPDATE ...
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?
Hello 2010/3/8 A B <gentosaker@gmail.com>: > Hello. > Doesn't this work in plpgsql functions? > > EXECUTE 'UPDATE mytable set ... ...' > IF FOUND THEN > do stuff.... > END IF; > it doesn't work - you have to use GET DIAGNOSTICS statement GET DIAGNOSTICS integer_var = ROW_COUNT; http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS regards Pavel Stehule > 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? > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >