Re: Getting number of affected row after performing update

On 19/02/10 05:42, Yan Cheng Cheok wrote:
>
> Of course, I get an error at line :
> IF @@ROWCOUNT=0 THEN
>
> May I know what is the correct PostgreSQL syntax for @@ROWCOUNT after update?

Best place for this sort of information is the manuals:

http://www.postgresql.org/docs/8.4/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

GET DIAGNOSTICS my_variable = ROWCOUNT;

--
   Richard Huxton
   Archonet Ltd