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
>