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

Hello

2010/3/8 A B <gentosaker(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>